SQL Reserved words - Mailing list pgsql-sql

From DUDLEY,DONALD (HP-Boise,ex1)
Subject SQL Reserved words
Date
Msg-id CBD6266EA291D5118144009027AA63350D9634E9@xboi05.boi.hp.com
Whole thread Raw
Responses Re: SQL Reserved words  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-sql
<p><font face="Arial" size="2">I am importing a database from Informix (SE 7.25) on HP-UX 11i to postgres 7.3.2 on RH 8
Linux.</font><br/><font face="Arial" size="2">In running the "CREATE TABLE" scripts while building the new database,
pgSQLseems to be choking on several of the column names.</font><p><font face="Arial" size="2">When I looked in the
appendixB1 of the Users Manual, I see that some of the column names are reserved words, either by pgSQL or by ANSI
SQL.</font><p><fontface="Arial" size="2">Some of the column names are: 'desc' (for 'description', collides with keyword
for'DESCENDING'), and 'group' (used in 'GROUP BY' clause).</font><p><font face="Arial" size="2">I'd like not to have to
alterthe many queries used in scripts and programs to change 'desc' to descr, and group to grp, for example. 
</font><p><fontface="Arial" size="2">Is there a way to tell pgSQL that you're referencing a column name and not a
reservedword?  Informix handled them ok...</font><p><font face="Arial" size="2">Thanks,</font><br /><font face="Arial"
size="2">Don</font>

pgsql-sql by date:

Previous
From: Lorraine.Dewey@companiongroup.com (Lorraine Dewey)
Date:
Subject: Optomizing left outer joins
Next
From: Bruce Williams
Date:
Subject: Invoice Numbers