X-Original-To: pgsql-sql@postgresql.org Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52]) by postgresql.org (Postfix) with SMTP id 5B2D9475EB2 for ; Thu, 13 Mar 2003 04:36:28 -0500 (EST) Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ; Thu Mar 13 10:36:28 2003 +0100 Received: œby rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id KAA01086; Thu, 13 Mar 2003 10:36:28 +0100 (MET) Message-ID: <3E70511B.760607F5@rodos.fzk.de> Date: Thu, 13 Mar 2003 10:36:27 +0100 From: Christoph Haller X-Mailer: Mozilla 4.77 [en] (X11; U; HP-UX B.10.20 9000/780) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Cc: ddelorme@dmdelorme.ca Subject: Re: The folding of unquoted names to lower case in PostgreSQL is Content-Type: text/plain; charset=iso-8859-2 Content-Transfer-Encoding: 7bit X-Archive-Number: 200303/329 X-Sequence-Number: 12368 > > 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.