Re: user column name - Mailing list pgsql-general

From Robert Treat
Subject Re: user column name
Date
Msg-id 1044562373.22884.206.camel@camel
Whole thread Raw
In response to Re: user column name  (Dennis Gearon <gearond@cvc.net>)
List pgsql-general
No. for a list of reserved words check out
http://www.gtsm.com/cgi/psearch?page=sql-keywords-appendix.html

You'll note that PostgreSQL largely bases it's list of reserved on the
SQL 92 & 99 specs and I'd strongly recommend to all to avoid usage of
those words, it's one of the easiest things you can do to stay spec
compliant.

Robert Treat

On Thu, 2003-02-06 at 13:59, Dennis Gearon wrote:
> Is 'Usrs' reserved? I plan on using that in an installation.
>
> 2/6/2003 10:31:08 AM, Stephan Szabo <sszabo@megazone23.bigpanda.com> wrote:
>
> >
> >On Thu, 6 Feb 2003, Peter Choe wrote:
> >
> >> is there a reason i can't use 'user' as a column name for a table?
> >
> >It's a reserved word.  You can use it inside double quotes,
> >but you'll need to always refer to it as "user" then.
> >
>


pgsql-general by date:

Previous
From: John Smith
Date:
Subject: Re: COPY with fk's slow
Next
From: "Fernando Papa"
Date:
Subject: pg_temp schemas