Re: Uppercase field names not found - Mailing list pgsql-admin

From David Stanaway
Subject Re: Uppercase field names not found
Date
Msg-id 1024404457.9198.17.camel@ciderbox
Whole thread Raw
In response to Uppercase field names not found  (Scot Wilcoxon <scot@wilcoxon.org>)
List pgsql-admin
On Mon, 2002-06-17 at 20:25, Scot Wilcoxon wrote:
> I've seen a few comments of people encountering this problem, but not
> yet a solution:
>
> Upper case field names in commands are forced to lower case and then not
> found.
>
> I was able to create a table with a field  called "ABC".
>
> "SELECT ABC FROM mytable;"
> emits the error
> "no such attribute or function abc"


If it is possible, you will have a much easier time if you change you
schema to use case folded names

EG:
CREATE TABLE Foo ( ... )
rather than: CREATE TABLE "Foo" ( ... )

otherwise.. You will need to change your code to quote all references to
the name:

EG:
$q = 'SELECT * from "Foo"';

If you don't put ["]'s around the object identifier, it gets case folded
to lower case.

--
David Stanaway

Attachment

pgsql-admin by date:

Previous
From: Scot Wilcoxon
Date:
Subject: Uppercase field names not found
Next
From: Tom Lane
Date:
Subject: Re: Postgres and mod_perl: table locked during vacuum?