RE: capitals in fieldnames

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(at)johalla(dot)de]
Sent: Saturday, March 31, 2001 5:02 PM
To: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly