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

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Andre Antonio Parmeggiani <aap(at)howto(dot)com(dot)br>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] 'user' sql reserved word ?
Date: 2000-03-04 17:05:58
Message-ID: Pine.LNX.4.21.0003040413080.489-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message KADAS ATHANASIOS 2000-03-05 12:29:41
Previous Message Chris Carbaugh 2000-03-03 17:34:30 Help with installing 6.5.3 on RedHat6.1 - specifying template