>
> 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.
