relation does not exist error

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=#

Responses

Browse pgsql-general by date

  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