Thread: access -> odbc 250 -> pgsql 64b5

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
-------------------------------------------------------------------

Giuseppe Tanzilli wrote:
>
> 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 ?

use " :)

hannu=> create table casetest(
hannu->   "UPPER" text,
hannu->   "upper" text
hannu-> );
CREATE
hannu=> insert into casetest values('A','a');
INSERT 29354 1
hannu=> insert into casetest values('A','A');
INSERT 29355 1
hannu=> insert into casetest values('a','a');
INSERT 29356 1
hannu=> insert into casetest values('a','A');
INSERT 29357 1
hannu=> select * from casetest;
UPPER|upper
-----+-----
A    |a
A    |A
a    |a
a    |A
(4 rows)

hannu=> select * from casetest where "UPPER"='A';
UPPER|upper
-----+-----
A    |a
A    |A
(2 rows)

---------
Hannu