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...
Thanks,
Don