| From: | "Joost Kraaijeveld" <J(dot)Kraaijeveld(at)Askesis(dot)nl> |
|---|---|
| To: | "Pgsql-Odbc (E-mail)" <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | Table and Column name folding question |
| Date: | 2005-01-18 09:19:52 |
| Message-ID: | A3D1526C98B7C1409A687E0943EAC41001EB34@obelix.askesis.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Hi,
I have a Clarion generated application that uses both quoted and unquoted table and column names. It is not consistant in the use of quotes: the same table sometimes is used with and sometimes without quotes. When used with quotes, the name of 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 is created 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(dot)Kraaijeveld(at)Askesis(dot)nl
web: www.askesis.nl
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Eckermann | 2005-01-18 14:59:22 | Re: Table and Column name folding question |
| Previous Message | Claudio Duffini | 2005-01-17 18:16:18 | Re: ODBC release plans? |