Re: Unable to query on existing table - ERROR: relation " zed" does not exist

Jaromír Kamler wrote on 21.05.2009 10:17:
> Hi,
> I have problem with simple query on existing table. On list below is
> evidently, that my table "Zed" exists, but when I ask that by SELECT, I
> have no result. When I list this table in PgAdmin3, all records I can
> see and when I want display this table thru QGIS, I can acces that.
>
> Table "Zed" was imported into PostgreSQL/PostGIS thru QGIS. Next table
> which I queryed was table administrativni_uzemi and here, how you can
> see below, all works fine. Interesting is that, that table "Zed" was
> imported by QGIS and working table "administrativni_uzemi" was imported
> by GRASS.
>
>
>
>
> Schema | Name | Type | Owner
> --------+--------------------------------+-------+----------
> ...
> ...
> public | Zed | table | postgres
>
> cvicna=# select * from Zed;

Apparently the table was created using double quotes and thus it is
case-sensitive now. You have to use

select * from "Zed";

Thomas