Re: relation does not exist error - Mailing list pgsql-general

From Michael Fuhr
Subject Re: relation does not exist error
Date
Msg-id 20041203031854.GA32151@winnie.fuhr.org
Whole thread Raw
In response to relation does not exist error  (Simon Wittber <simonwittber@gmail.com>)
List pgsql-general
On Fri, Dec 03, 2004 at 11:01:16AM +0800, Simon Wittber wrote:

>          List of relations
>  Schema |   Name    | Type  | Owner
> --------+-----------+-------+-------
>  public | Customers | table | simon
>  public | Persons   | table | simon
> (2 rows)
>
> WMSDV=# select * from Customers;
> ERROR:  relation "customers" does not exist

See the "Identifiers and Key Words" section in the "SQL Syntax" of
the PostgreSQL documentation.  Pay particular attention to what it
says about case sensitivity, case folding, and quoting of identifiers.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: Simon Wittber
Date:
Subject: relation does not exist error
Next
From: Doug McNaught
Date:
Subject: Re: relation does not exist error