relation does not exist error
От | Simon Wittber |
---|---|
Тема | relation does not exist error |
Дата | |
Msg-id | 4e4a11f80412021901295079b3@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: relation does not exist error
Re: relation does not exist error |
Список | 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=#
В списке pgsql-general по дате отправления: