| From: | kornale(at)zdnetmail(dot)com (Alex K(dot)) |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | what is wrong with this SQL? |
| Date: | 2001-09-20 22:18:46 |
| Message-ID: | 99fb7937.0109201418.7ff032a2@posting.google.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 | Vladimir Konrad | 2001-09-20 22:42:20 | Re: what is wrong with this SQL? |
| Previous Message | Denis Perchine | 2001-09-20 21:08:19 | Re: Recreating indices safely |