Reserved words and workarounds...
От
Matt Clark
Тема
Reserved words and workarounds...
Дата
Msg-id
200209122124.g8CLOhv27057@rushe.aero.org
Список
Дерево обсуждения
Reserved words and workarounds... Matt Clark <mclark@rushe.aero.org>
Re: Reserved words and workarounds... Tom Lane <tgl@sss.pgh.pa.us>
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
В списке pgsql-novice по дате отправления