Thread: Case sensitive

Przemysław Słupkowski wrote:

> Hi
> I have a question about creating psql scripts. Is a posible to use
> upper in names of functions

The SQL standard dictates that unquoted identifiers have their case
folded to upper case. Postgresql ignores this altogether under the claim
that "uppercase is ugly". PostgreSQL folds unquoted identifiers to
lowercase. If you are not converting from a different database, this
should not matter to you.

In order to call upper case functions, or upper case tables for that
matter, you have to quote them. Thus, instead of saying
Select * from TABLE
You need to do
select * from "TABLE"

This will allow you to call uppercase identifiers.

--
Shachar Shemesh
Lingnu Open Systems Consulting
http://www.lingnu.com/