access -> odbc 250 -> pgsql 64b5

From: Giuseppe Tanzilli <g(dot)tanzilli(at)eurolink(dot)it>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: access -> odbc 250 -> pgsql 64b5
Date: 1998-11-03 12:12:26
Message-ID: 363EF32A.8D9BD78E@eurolink.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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(dot)tanzilli(at)flashnet(dot)it Sede di Frosinone
Eurolink S.r.l. mailto: info(dot)frosinone(at)flashnet(dot)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(at)king(dot)fr(dot)flashnet(dot)it
-------------------------------------------------------------------

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Hannu Krosing 1998-11-03 13:15:45 Re: [INTERFACES] access -> odbc 250 -> pgsql 64b5
Previous Message Jose' Soares 1998-11-03 10:01:38 PSQLODBC