Skip site navigation (1) Skip section navigation (2)

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

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Unable to query on existing table - ERROR: relation &quot;zed&quot; does not exist
Date: 2009-05-21 08:28:16
Message-ID: gv33av$ihe$1@ger.gmane.org (view raw or flat)
Thread:
Lists: pgsql-novice
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


In response to

Responses

pgsql-novice by date

Next:From: Jaromír KamlerDate: 2009-05-21 11:20:13
Subject: Re: Re: Unable to query on existing table - ERROR: relation &quot;zed&quot; does not exist
Previous:From: Jaromír KamlerDate: 2009-05-21 08:17:26
Subject: Unable to query on existing table - ERROR: relation &quot;zed&quot; does not exist

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group