Re: ERROR: relation "mytable" does not exist - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: ERROR: relation "mytable" does not exist
Date
Msg-id 200505071243.35643.peter_e@gmx.net
Whole thread Raw
In response to ERROR: relation "mytable" does not exist  ("Peter Schonefeld" <peter.schonefeld@bigpond.com>)
List pgsql-admin
Peter Schonefeld wrote:
> CREATE TABLE "Country"

> If i try SELECT * FROM Country, i get 'ERROR: relation "country" does
> not exist.

If you write "Country" once, then you might write "Country", not
Country, all the time, because otherwise the name will be converted to
lower case.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Backup when the database is missing all of the pg_* tables
Next
From: Vasilis Ventirozos
Date:
Subject: thats funny :)