Using psql and running as the owner of the table "app" I try to access the columns of the table like so:
SELECT * FROM app;
which returns all the columns in the table including the one I'm interested in, which is "companyID". If instead I use something like:
SELECT companyID FROM app;
I get the following:
ERROR: column "companyid" does not exist
even though the column DOES exist (the previous query returned "companyID" as one of the column headers). Any suggestions as to what I might be missing? I'm running Postgres 7.4.1.
Regards, Iker
You need to quote the table name if it contains upper case or strange characters:
SELECT "companyID" FROM app;
-- Mark Gibson <[EMAIL PROTECTED]> Web Developer & Database Admin Cromwell Tools Ltd. Leicester, England.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
