From: | Hannu Krosing <hannu(at)trust(dot)ee> |
---|---|
To: | Giuseppe Tanzilli <g(dot)tanzilli(at)eurolink(dot)it> |
Cc: | pgsql-interfaces(at)postgreSQL(dot)org |
Subject: | Re: [INTERFACES] access -> odbc 250 -> pgsql 64b5 |
Date: | 1998-11-03 13:15:45 |
Message-ID: | 363F0201.6FF7706F@trust.ee |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Dinica Ciprian | 1998-11-03 13:30:51 | I do have a problem with pgaccess |
Previous Message | Giuseppe Tanzilli | 1998-11-03 12:12:26 | access -> odbc 250 -> pgsql 64b5 |