Re: Table and Column name folding question

--- Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>
wrote:

> 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)?

Correct. PostgreSQL will look for an exact match,
where quoted identifier (table, column etc.) names are
used.

There is a great deal of discussion of this question
in the list archives (try the pgsql-general list).

>
>
>
> 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
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

__________________________________
Do you Yahoo!?
Meet the all-new My Yahoo! - Try it today!
http://my.yahoo.com