Re: Not existing relations ... - Mailing list pgsql-general

> DataBase=# \dt
>           List of relations
>        Name        | Type  |  Owner
> -------------------+-------+----------
>  FirstTable        | table | postgres
>  SecondTable       | table | postgres
>  ThirdTable        | table | postgres
> (3 rows)
>
> DataBase=# select * from FirstTable;
> ERROR:  Relation 'firsttable' does not exist

select * from "FirstTable";

will probably work.

You may also (if you do not need to access them from MSAccess any more)

ALTER TABLE "FirstTable" RENAME TO firsttable;

If you do not enclose the table names in double quotes ("), they are
converted to lower case, AFAIK.

Good luck!

Antonio