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=#
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
