capitals in fieldnames - Mailing list pgsql-general

From Markus Mohr
Subject capitals in fieldnames
Date
Msg-id 3AC653EB.5AA66C5C@johalla.de
Whole thread Raw
List pgsql-general
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?

thanks
markus

pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: Re: where does the -i go?
Next
From: "IGB.NET"
Date:
Subject: ...