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

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:23:32
Message-ID: 40225FF4.1090900@cromwell.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Mark Gibson wrote:

>
> You need to quote the table name if it contains upper case or strange
> characters:
>
> SELECT "companyID" FROM app;
>
Obviously I meant column name, but it applies to any object identifier ;)

--
Mark Gibson <gibsonm(at)cromwell(dot)co(dot)uk>
Web Developer & Database Admin
Cromwell Tools Ltd.
Leicester, England.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Carlos Ojea Castro 2004-02-05 15:24:04 : Proper tool to display graphics?
Previous Message Karsten Hilbert 2004-02-05 15:22:09 Re: ERROR: column 'xxx' does not exist (under v. 7.4.1)