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

Simon Wittber <simonwittber@gmail.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