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.Kraaijeveld@Askesis.nl
web: www.askesis.nl

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

--- Joost Kraaijeveld <J.Kraaijeveld@Askesis.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.Kraaijeveld@Askesis.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



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)