capitals in fieldnames

From: Markus Mohr <markus(at)johalla(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: capitals in fieldnames
Date: 2001-03-31 22:02:19
Message-ID: 3AC653EB.5AA66C5C@johalla.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-03-31 23:57:50 Re: [SQL] Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP
Previous Message Andrew Hammond 2001-03-31 21:16:53 Re: A valuable addition to PHP...