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/