Thread: 'user' sql reserved word ?

Hi All,

I tried to create a silly table :

=> create table user (user text);
ERROR:  parser: parse error at or near "user"

On postgres 6.5.3 it was ok .. and
create table foo(foo text);
works fine :-)

Any idea ?

Thanks,
Andre

I ran into the same thing.. it must be a reserved word..
--Bob

-----------------------------------------
You got two choices jack: start talkin' or start hurtin'
   -- Mr. T

On Wed, 1 Mar 2000, Andre Antonio Parmeggiani wrote:

>
> Hi All,
>
> I tried to create a silly table :
>
> => create table user (user text);
> ERROR:  parser: parse error at or near "user"
>
> On postgres 6.5.3 it was ok .. and
> create table foo(foo text);
> works fine :-)
>
> Any idea ?
>
> Thanks,
> Andre
>
>
> ************
>
>

Andre Antonio Parmeggiani writes:

> => create table user (user text);
> ERROR:  parser: parse error at or near "user"

USER is a reserved word in SQL92. To use it, enclose it in double quotes.

--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden