The folding of unquoted names to lower case in PostgreSQL is incompatible with the SQL standard

Поиск
Список
Период
Сортировка
От David Delorme
Тема The folding of unquoted names to lower case in PostgreSQL is incompatible with the SQL standard
Дата
Msg-id PMEEIDMOLBOIEHAGBLOPMENKCAAA.ddelorme@dmdelorme.ca
обсуждение исходный текст
Список pgsql-sql
I am trying to integrate MapInfo with a postgresql backend.
Problem:
MapInfo query uses both quoted and unquoted statements i.e.
"MAPINFO"."MAPINFO_MAPCATALOG" and mapinfo.mapinfo_mapcatalogI can not change the query statements that MapInfo uses to
talkto the odbc
 
driver.I am in the process of changing to grass5 for all my map production.

I have a schema called MAPINFO and a table called MAPINFO_MAPCATALOG.
I need to fold unquoted names to uppercase.

I really only need to change this behaviour for this schema.

David Delorme
http://dmdelorme.ca



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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Special characters in SQL queries
Следующее
От: mila
Дата:
Сообщение: LEFT JOIN and missing values