From: Hannu Krosing <hannu@trust.ee>
To: Giuseppe Tanzilli <g.tanzilli@eurolink.it>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] access -> odbc 250 -> pgsql 64b5
Date: Tue, 03 Nov 1998 15:15:45 +0200
Message-ID: <363F0201.6FF7706F@trust.ee> (raw)
References: <363EF32A.8D9BD78E@eurolink.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: hannu@trust.ee, g.tanzilli@eurolink.it
Subject: Re: [INTERFACES] access -> odbc 250 -> pgsql 64b5
In-Reply-To: <363F0201.6FF7706F@trust.ee>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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