From: | Simon Wittber <simonwittber(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | relation does not exist error |
Date: | 2004-12-03 03:01:16 |
Message-ID: | 4e4a11f80412021901295079b3@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm evaluationg PostgreSQL 8.0 beta 5 for a new development project.
I've created a user 'simon' and a database named 'WMSDV'.
I've created some tables (see below) and assigned arwdRxt privledges
to the 'simon' user.
However, when i use psql, I am unable to select these tables. I
receive a 'relation "'tabename' does not exist" error. I'm completely
new to PostgreSQL, and this problem has me stumped.
Can anyone point me in the right direction?
Sw.
WMSDV=# \dt
List of relations
Schema | Name | Type | Owner
--------+-----------+-------+-------
public | Customers | table | simon
public | Persons | table | simon
(2 rows)
WMSDV=# select * from Customers;
ERROR: relation "customers" does not exist
WMSDV=# select * from public.Customers;
ERROR: relation "public.customers" does not exist
WMSDV=#
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2004-12-03 03:18:54 | Re: relation does not exist error |
Previous Message | Berend Tober | 2004-12-03 02:56:41 | Re: Rules |