Re: The folding of unquoted names to lower case in PostgreSQL is - Mailing 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_mapcatalog
> 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.
>

How about creating a secondary schema as

CREATE SCHEMA mapinfo ;
CREATE VIEW mapinfo.mapinfo_mapcatalog AS       SELECT * FROM "MAPINFO"."MAPINFO_MAPCATALOG" ;

Regards, Christoph

PS Please drop a note if it works.