Received: from fr.flashnet.it (root@dns.fr.flashnet.it [194.247.172.132]) by hub.org (8.9.1/8.9.1) with ESMTP id HAA03635 for ; Tue, 3 Nov 1998 07:12:25 -0500 (EST) (envelope-from g.tanzilli@eurolink.it) Received: from eurolink.it (giuseppe.fr.flashnet.it [194.247.172.135]) by fr.flashnet.it (8.8.8/8.8.8) with ESMTP id NAA06724 for ; Tue, 3 Nov 1998 13:12:23 +0100 Message-ID: <363EF32A.8D9BD78E@eurolink.it> Date: Tue, 03 Nov 1998 13:12:26 +0100 From: Giuseppe Tanzilli X-Mailer: Mozilla 4.5 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org Subject: access -> odbc 250 -> pgsql 64b5 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, when exporting tables from access if the table/field are uppercase/mixed case in Acces get created in postgresql as same case in psql we need to quote them as "Upper" Maybe will be good to traslate in lowercase all identifiers before passing it to pgsql (in the odbc side). any comment ? psql is not case sentitive how it work ? thanks -- ----------------------------------------------------------------- Giuseppe Tanzilli Flashnet S.p.A. Telecomunicazioni mailto: g.tanzilli@flashnet.it Sede di Frosinone Eurolink S.r.l. mailto: info.frosinone@flashnet.it Tel: +39-775-830012 http://www.flashnet.it Fax: +39-775-201321 EUnet Business Partner http://www.eurolink.it AIIP and ANFOV associated PGP Key: finger giuseppe@king.fr.flashnet.it -------------------------------------------------------------------