I am attempting to convert an existing DB and client code from DB2 and/or Oracle
to run using PostgreSQL.
One major problem is that there appear to be a number of words that cannot be
used as column names.
Specifically, the DB creation SQL includes the following:
create table table1 (init-id integer, offset integer);
which barfs at the column-name "offset". Likewise, any SQL which attempt to
insert a value into "offset" causes a problem.....
Changing the source code of the client program, which generates the SQL, is not
an option. Is there a fix or kludge which will allow Postgres to get by this
problem?
What other words are restricted from being used as column names?
Thanks,
Matt