| From: | Shachar Shemesh <psql(at)shemesh(dot)biz> |
|---|---|
| To: | Przemysław Słupkowski <przemyslaw(dot)slupkowski(at)euro(dot)coig(dot)pl> |
| Cc: | odbc postgres <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | Re: Case sensitive |
| Date: | 2004-03-17 13:26:56 |
| Message-ID: | 40585220.8000909@shemesh.biz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2004-03-17 15:01:53 | Re: Some problems with Access and ODBC to PostgreSQL |
| Previous Message | Przemysław Słupkowski | 2004-03-17 12:26:47 | Case sensitive |