From: | "Vladimir Konrad" <vladimir(at)wit(dot)uklinux(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: what is wrong with this SQL? |
Date: | 2001-09-20 22:42:20 |
Message-ID: | 9ods77$smm$1@news.tht.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
USR_LOGIN_USER_ID varchar2(16) ,
USR_PASSWORD varchar2(16) ,
There is not varchar2 type!
regards...
Alex K. <kornale(at)zdnetmail(dot)com> wrote in message
news:99fb7937(dot)0109201418(dot)7ff032a2(at)posting(dot)google(dot)com(dot)(dot)(dot)
> create table USERS (
> ID decimal(19) CONSTRAINT primary_usr_oid PRIMARY KEY,
> WRITE_COUNT decimal(19) NOT NULL,
> CLASS decimal(10) NOT NULL,
> STATUS decimal(3) NOT NULL,
> USR_LOGIN_USER_ID varchar2(16) ,
> USR_PASSWORD varchar2(16) ,
> USR_PERSON_FIRST_NAME varchar(32) ,
> USR_PERSON_MIDDLE_NAME varchar(32) ,
> USR_PERSON_LAST_NAME varchar(32) ,
> USR_PERSON_SALUTATION varchar(32) ,
> USR_PERSON_SUFFIX varchar(32)
> );
>
> when i am in psql and i do: \i createUsersTable.sql i get this error:
> psql:createUsersTable.sql:13: ERROR: parser: parse error at or near "("
>
> What is this?
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2001-09-20 23:33:18 | Re: Global constants |
Previous Message | Alex K. | 2001-09-20 22:18:46 | what is wrong with this SQL? |