It was initially created with quotes. If you want to access it the other way, you need to rename it:
ALTER TABLE foo RENAME COLUMN "BGF" TO BGF;
Hope that helps,
Mike Mascari
-----Original Message-----
From: Markus Mohr [SMTP:markus@johalla.de]
Sent: Saturday, March 31, 2001 5:02 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] capitals in fieldnames
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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
