Re: capitals in fieldnames - Mailing list pgsql-general

From Richard Huxton
Subject Re: capitals in fieldnames
Date
Msg-id 3AC75667.1B78930D@archonet.com
Whole thread Raw
In response to capitals in fieldnames  (Markus Mohr <markus@johalla.de>)
List pgsql-general
Markus Mohr wrote:
>
> Hi!
>
> I use postgres 7.0.3 on Linux and have the following problem:
> there is a field with the name 'BGF' and I can access it only with:
>
> SELECT "BGF" FROM <table>;
>
> Neither
>
> SELECT BGF ... nor
> SELECT bgf ...
>
> work. But AFAIK all three should do. Whats wrong here?

PostgreSQL lower-cases everything as it is used unless you put it in
double-quotes. The two examples should work if your field was 'bgf' -
you must have created it with double-quotes or imported it from another
system e.g. MS-Access.

It can be irritating, I agree and does make porting from Access more
difficult but I can't see it changing.

- Richard Huxton

pgsql-general by date:

Previous
From: Mike Mascari
Date:
Subject: RE: RE: Re: Dissapearing indexes, what's that all about?
Next
From: Daniel ?erud
Date:
Subject: Re: RE: RE: Re: Dissapearing indexes, what's that all about?