Skip site navigation (1) Skip section navigation (2)

Re: Reserved words and workarounds...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Matt Clark <mclark(at)rushe(dot)aero(dot)org>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Reserved words and workarounds...
Date: 2002-09-13 04:38:54
Message-ID: 15437.1031891934@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Matt Clark <mclark(at)rushe(dot)aero(dot)org> writes:
> Changing the source code of the client program, which generates the
> SQL, is not an option.

I'm afraid you're SOL then :-(

> What other words are restricted from being used as column names?

See 
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/sql-keywords-appendix.html
for a pretty complete rundown.  Note that LIMIT is considered a reserved
word per SQL99 (though not per SQL92) ... so you will not get a whole
lot of sympathy for any request to make it unreserved.  We already do
our best not to reserve more keywords than we have to.

			regards, tom lane

In response to

pgsql-novice by date

Next:From: sdeelDate: 2002-09-14 04:41:49
Subject: how to process?
Previous:From: Oliver ElphickDate: 2002-09-12 22:25:34
Subject: Re: recent Debian Postgres security update

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group