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.
> >
>
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 |