From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: DUDLEY,DONALD (HP-Boise,ex1) <donald.dudley@hp.com>
Cc: 'pgsql-sql@postgresql.org' <pgsql-sql@postgresql.org>
Subject: Re: SQL Reserved words
Date: Wed, 23 Apr 2003 11:11:25 -0700 (PDT)
Message-ID: <20030423110949.V86759-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <CBD6266EA291D5118144009027AA63350D9634E9@xboi05.boi.hp.com>
On Tue, 22 Apr 2003, DUDLEY,DONALD (HP-Boise,ex1) wrote:
> I am importing a database from Informix (SE 7.25) on HP-UX 11i to postgres
> 7.3.2 on RH 8 Linux.
> In running the "CREATE TABLE" scripts while building the new database, pgSQL
> seems to be choking on several of the column names.
> When I looked in the appendix B1 of the Users Manual, I see that some of the
> column names are reserved words, either by pgSQL or by ANSI SQL.
> Some of the column names are: 'desc' (for 'description', collides with
> keyword for 'DESCENDING'), and 'group' (used in 'GROUP BY' clause).
> I'd like not to have to alter the many queries used in scripts and programs
> to change 'desc' to descr, and group to grp, for example.
> Is there a way to tell pgSQL that you're referencing a column name and not a
> reserved word? Informix handled them ok...
You can use double quotes around the names (in all cases where you refer
to it) to use it as an identifier, but that doesn't help if you don't want
to change the queries.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sszabo@megazone23.bigpanda.com, donald.dudley@hp.com
Subject: Re: SQL Reserved words
In-Reply-To: <20030423110949.V86759-100000@megazone23.bigpanda.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox