The folding of unquoted names to lower case in PostgreSQL is incompatible with the SQL standard - Mailing list pgsql-sql

From David Delorme
Subject The folding of unquoted names to lower case in PostgreSQL is incompatible with the SQL standard
Date
Msg-id PMEEIDMOLBOIEHAGBLOPMENKCAAA.ddelorme@dmdelorme.ca
Whole thread Raw
List 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 by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Special characters in SQL queries
Next
From: mila
Date:
Subject: LEFT JOIN and missing values