Re: 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/


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faqs/FAQ.html