From: Christoph Haller <ch@rodos.fzk.de>
To: pgsql-sql@postgresql.org
Cc: ddelorme@dmdelorme.ca
Subject: Re: The folding of unquoted names to lower case in PostgreSQL is
Date: Thu, 13 Mar 2003 10:36:27 +0100
Message-ID: <3E70511B.760607F5@rodos.fzk.de> (raw)
>
> 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ch@rodos.fzk.de, ddelorme@dmdelorme.ca
Subject: Re: The folding of unquoted names to lower case in PostgreSQL is
In-Reply-To: <3E70511B.760607F5@rodos.fzk.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox