Re: relation does not exist error

Simon Wittber <simonwittber(at)gmail(dot)com> writes:

> WMSDV=# \dt
> 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

Identifiers get mashed to lower case unless you quote them:

SELECT * FROM "Customers";

-Doug