pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedaccess -> odbc 250 -> pgsql 64b5
2+ messages / 2 participants
[nested] [flat]
* access -> odbc 250 -> pgsql 64b5
@ 1998-11-03 12:12 Giuseppe Tanzilli <g.tanzilli@eurolink.it>
0 siblings, 1 reply; 2+ messages in thread
From: Giuseppe Tanzilli @ 1998-11-03 12:12 UTC (permalink / raw)
To: 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
-------------------------------------------------------------------
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [INTERFACES] access -> odbc 250 -> pgsql 64b5
@ 1998-11-03 13:15 Hannu Krosing <hannu@trust.ee>
parent: Giuseppe Tanzilli <g.tanzilli@eurolink.it>
0 siblings, 0 replies; 2+ messages in thread
From: Hannu Krosing @ 1998-11-03 13:15 UTC (permalink / raw)
To: Giuseppe Tanzilli <g.tanzilli@eurolink.it>; +Cc: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1998-11-03 13:15 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-11-03 12:12 access -> odbc 250 -> pgsql 64b5 Giuseppe Tanzilli <g.tanzilli@eurolink.it>
1998-11-03 13:15 ` Hannu Krosing <hannu@trust.ee>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox