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

Yes, you are right. I apologize for my stupid question, but this little dreamt that me :-). I wrote there Zed with big "Z"
but I have "forgot" double quotes. Is there some possibility to get out case-sensitivity?


Regards,

Jaromír Kamler
 
______________________________________________________________
> Od: spam_eater@gmx.net
> Komu: pgsql-novice@postgresql.org
> Datum: 21.05.2009 11:06
> Předmět: [NOVICE] 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


--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice