Re: user column name

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: gearond(at)cvc(dot)net
Cc: Peter Choe <choepete(at)mindspring(dot)com>, Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: user column name
Date: 2003-02-06 20:12:53
Message-ID: 1044562373.22884.206.camel@camel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)megazone23(dot)bigpanda(dot)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.
> >
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Fernando Papa 2003-02-06 20:16:53 pg_temp schemas
Previous Message John Smith 2003-02-06 20:06:02 Re: COPY with fk's slow