Skip site navigation (1) Skip section navigation (2)

Reserved words and workarounds...

From: Matt Clark <mclark(at)rushe(dot)aero(dot)org>
To: pgsql-novice(at)postgresql(dot)org
Subject: Reserved words and workarounds...
Date: 2002-09-12 21:24:43
Message-ID: 200209122124.g8CLOhv27057@rushe.aero.org (view raw or flat)
Thread:
Lists: pgsql-novice
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


 


Responses

pgsql-novice by date

Next:From: Imre OolbergDate: 2002-09-12 21:58:24
Subject: recent Debian Postgres security update
Previous:From: Vernon WuDate: 2002-09-12 14:51:46
Subject: How to make i18n work?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group