On Thu, Feb 05, 2004 at 10:00:21AM -0500, Iker Arizmendi wrote:
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
SELECT "companyID" FROM app;
You've stored a case sensitive column name in the table, but
by default Postgres will fold all identifiers to lower case
unless quoted.
--Joe
--
Joe Sunday <su****@csh.rit.edu>
http://www.csh.rit.edu/~sunday/
Computer Science House, Rochester Inst. Of Technology
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html