From: | " Jaromír Kamler" <kamler(at)centrum(dot)cz> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Re: Unable to query on existing table - ERROR: relation " zed" does not exist |
Date: | 2009-05-21 11:20:13 |
Message-ID: | 200905211320.30801@centrum.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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(at)gmx(dot)net
> Komu: pgsql-novice(at)postgresql(dot)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(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Kellerer | 2009-05-21 11:40:00 | Re: Unable to query on existing table - ERROR: relation " zed" does not exist |
Previous Message | Thomas Kellerer | 2009-05-21 08:28:16 | Re: Unable to query on existing table - ERROR: relation " zed" does not exist |