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 по дате отправления
От: Vernon Wu
Дата:
Сообщение: How to make i18n work?
От: Imre Oolberg
Дата:
Поиск
Список
Период
Сортировка
Искать
FAQ