Re: Reserved words and workarounds... - Mailing list pgsql-novice

From Tom Lane
Subject Re: Reserved words and workarounds...
Date
Msg-id 15437.1031891934@sss.pgh.pa.us
Whole thread Raw
In response to Reserved words and workarounds...  (Matt Clark <mclark@rushe.aero.org>)
List pgsql-novice
Matt Clark <mclark@rushe.aero.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

pgsql-novice by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: recent Debian Postgres security update
Next
From: "sdeel"
Date:
Subject: how to process?