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@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