Re: what is wrong with this SQL?

kornale@zdnetmail.com (Alex K.) writes:

>     USR_LOGIN_USER_ID        varchar2(16)    ,
>     USR_PASSWORD            varchar2(16)    ,

> 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 "("

My previous mail was wrong, its the "varchar2" that's messing things
up--PG has no such type.  The error message isn't too helpful.

Change it to "text" or regular "varchar" and you should be OK.

-Doug
--
In a world of steel-eyed death, and men who are fighting to be warm,
Come in, she said, I'll give you shelter from the storm.    -Dylan