Thread: 'user' sql reserved word ?

'user' sql reserved word ?

From
Andre Antonio Parmeggiani
Date:
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


Re: [ADMIN] 'user' sql reserved word ?

From
Bob Zoller
Date:
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
>
>
> ************
>
>


Re: [ADMIN] 'user' sql reserved word ?

From
Peter Eisentraut
Date:
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