Re: [INTERFACES] access -> odbc 250 -> pgsql 64b5

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