Received: from bonk.trust.ee (IDENT:root@bonk.trust.ee [194.106.111.130])
	by hub.org (8.9.1/8.9.1) with ESMTP id IAA09728
	for <pgsql-interfaces@postgreSQL.org>;
	Tue, 3 Nov 1998 08:12:19 -0500 (EST) (envelope-from hannu@trust.ee)
Received: from trust.ee (wink [194.106.111.151])
	by bonk.trust.ee (8.8.7/8.8.7) with ESMTP id QAA01456;
	Tue, 3 Nov 1998 16:06:14 +0200
Message-ID: <363F0201.6FF7706F@trust.ee>
Date: Tue, 03 Nov 1998 15:15:45 +0200
From: Hannu Krosing <hannu@trust.ee>
X-Mailer: Mozilla 4.06 [en] (Win95; I)
MIME-Version: 1.0
To: Giuseppe Tanzilli <g.tanzilli@eurolink.it>
CC: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] access -> odbc 250 -> pgsql 64b5
References: <363EF32A.8D9BD78E@eurolink.it>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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