ERROR: column 'xxx' does not exist (under v. 7.4.1)

From: Iker Arizmendi <iker(at)research(dot)att(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: ERROR: column 'xxx' does not exist (under v. 7.4.1)
Date: 2004-02-05 15:00:21
Message-ID: 40225A85.6060405@research.att.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mark Gibson 2004-02-05 15:17:11 Re: ERROR: column 'xxx' does not exist (under v. 7.4.1)
Previous Message Mark Gibson 2004-02-05 14:46:57 dblink - custom datatypes don't work