access -> odbc 250 -> pgsql 64b5 - Mailing list pgsql-interfaces

From Giuseppe Tanzilli
Subject access -> odbc 250 -> pgsql 64b5
Date
Msg-id 363EF32A.8D9BD78E@eurolink.it
Whole thread Raw
List 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.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
-------------------------------------------------------------------



pgsql-interfaces by date:

Previous
From: "Jose' Soares"
Date:
Subject: PSQLODBC
Next
From: Hannu Krosing
Date:
Subject: Re: [INTERFACES] access -> odbc 250 -> pgsql 64b5