From: | Mark Gibson <gibsonm(at)cromwell(dot)co(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ERROR: column 'xxx' does not exist (under v. 7.4.1) |
Date: | 2004-02-05 15:17:11 |
Message-ID: | 40225E77.8050301@cromwell.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
> 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 <gibsonm(at)cromwell(dot)co(dot)uk>
Web Developer & Database Admin
Cromwell Tools Ltd.
Leicester, England.
From | Date | Subject | |
---|---|---|---|
Next Message | Karsten Hilbert | 2004-02-05 15:22:09 | Re: ERROR: column 'xxx' does not exist (under v. 7.4.1) |
Previous Message | Iker Arizmendi | 2004-02-05 15:00:21 | ERROR: column 'xxx' does not exist (under v. 7.4.1) |