--- Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>
> 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)?
Correct. PostgreSQL will look for an exact match,
where quoted identifier (table, column etc.) names are
There is a great deal of discussion of this question
in the list archives (try the pgsql-general list).
> 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
> ---------------------------(end of
> TIP 4: Don't 'kill -9' the postmaster
Do you Yahoo!?
Meet the all-new My Yahoo! - Try it today!
In response to
pgsql-odbc by date
|Next:||From: Együd Csaba||Date: 2005-01-18 20:49:23|
|Subject: psqlodbc 08.00.0004 - questions|
|Previous:||From: Joost Kraaijeveld||Date: 2005-01-18 09:19:52|
|Subject: Table and Column name folding question|