Table and Column name folding question - Mailing list pgsql-odbc

From Joost Kraaijeveld
Subject Table and Column name folding question
Date
Msg-id A3D1526C98B7C1409A687E0943EAC41001EB34@obelix.askesis.nl
Whole thread Raw
Responses Re: Table and Column name folding question
List pgsql-odbc
Hi,

I have a Clarion generated application that uses both quoted and unquoted table and column names. It is not consistant
inthe use of quotes: the same table sometimes is used with and sometimes without quotes. When used with quotes, the
nameof the table/column is always uppercase. Without quotes it is in lowercase. 

The PostgreSQL docs say that unquoted names are folded to lower case.

But does that also mean that quoted upper case table and column names cannot be used to access a table or column that
iscreated without quotes (lower case)? 



Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J.Kraaijeveld@Askesis.nl
web: www.askesis.nl

pgsql-odbc by date:

Previous
From: "Claudio Duffini"
Date:
Subject: Re: ODBC release plans?
Next
From: Jeff Eckermann
Date:
Subject: Re: Table and Column name folding question