Not able to find a table

Поиск
Список
Период
Сортировка
От Dale Seaburg
Тема Not able to find a table
Дата
Msg-id FFE61182-BD3B-434A-9713-6AF470422BA8@verizon.net
обсуждение исходный текст
Ответы Re: Not able to find a table  (Brian Hurt <bhurt@janestcapital.com>)
Re: Not able to find a table  (Michael Fuhr <mike@fuhr.org>)
Re: Not able to find a table  (Michael Glaesemann <grzm@seespotcode.net>)
Re: Not able to find a table  (Dale Seaburg <kg5lt@verizon.net>)
Список pgsql-novice
I have a database that can be accessed and used correctly via ODBC
and MS-Access.  But when I try to do a simple SQL SELECT query in
psql, I get an error that the table can't be found: Relation
"instrument_type" does not exist.  Yet, when I do a "\d" command, I
see the table named "Instrument_Type" in the "public" schema.  I use
the database owner as the user id for psql.

I need some help where to look in, say pgAdmin III (my tool of choice
for database creation / maintenance) for a clue as to why I am
getting this error.

Thanks for any help, ideas, clues, starting points.

Dale



В списке pgsql-novice по дате отправления:

Предыдущее
От: Luca Ferrari
Дата:
Сообщение: expain INSERT INTO
Следующее
От: Brian Hurt
Дата:
Сообщение: Re: Not able to find a table