Re: user column name

Поиск
Список
Период
Сортировка
От Robert Treat
Тема Re: user column name
Дата
Msg-id 1044562373.22884.206.camel@camel
обсуждение исходный текст
Ответ на Re: user column name  (Dennis Gearon <gearond@cvc.net>)
Список 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 по дате отправления:

Предыдущее
От: John Smith
Дата:
Сообщение: Re: COPY with fk's slow
Следующее
От: "Fernando Papa"
Дата:
Сообщение: pg_temp schemas