| 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: | Whole Thread | Raw Message | 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 |