SQL Reserved words

Поиск
Список
Период
Сортировка
От DUDLEY,DONALD (HP-Boise,ex1)
Тема SQL Reserved words
Дата
Msg-id CBD6266EA291D5118144009027AA63350D9634E9@xboi05.boi.hp.com
обсуждение исходный текст
Ответы Re: SQL Reserved words  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-sql
<p><font face="Arial" size="2">I am importing a database from Informix (SE 7.25) on HP-UX 11i to postgres 7.3.2 on RH 8
Linux.</font><br/><font face="Arial" size="2">In running the "CREATE TABLE" scripts while building the new database,
pgSQLseems to be choking on several of the column names.</font><p><font face="Arial" size="2">When I looked in the
appendixB1 of the Users Manual, I see that some of the column names are reserved words, either by pgSQL or by ANSI
SQL.</font><p><fontface="Arial" size="2">Some of the column names are: 'desc' (for 'description', collides with keyword
for'DESCENDING'), and 'group' (used in 'GROUP BY' clause).</font><p><font face="Arial" size="2">I'd like not to have to
alterthe many queries used in scripts and programs to change 'desc' to descr, and group to grp, for example. 
</font><p><fontface="Arial" size="2">Is there a way to tell pgSQL that you're referencing a column name and not a
reservedword?  Informix handled them ok...</font><p><font face="Arial" size="2">Thanks,</font><br /><font face="Arial"
size="2">Don</font>

В списке pgsql-sql по дате отправления:

Предыдущее
От: Lorraine.Dewey@companiongroup.com (Lorraine Dewey)
Дата:
Сообщение: Optomizing left outer joins
Следующее
От: Bruce Williams
Дата:
Сообщение: Invoice Numbers