Re: Can not access the public schema

Поиск
Список
Период
Сортировка
От Carol Walter
Тема Re: Can not access the public schema
Дата
Msg-id 9BCC6B68-7086-42AC-8D05-6B6C9CA4F50E@indiana.edu
обсуждение исходный текст
Ответ на Can not access the public schema  ("M.Khaled" <mohamed_mohamed_186@yahoo.com>)
Список pgsql-admin
Дерево обсуждения
I'm in an academic environment.  One of the problems that I often have, is that students will put upper case letters in table names.  If this is done, and the student doesn't quote the table or column name this error is the result.  Is this possibly happening?

Carol
On Jan 18, 2008, at 11:42 AM, M.Khaled wrote:

Hi,
I had installed postgresql-8.1.9, But when I tried to run any sql statement like the following:
(1)select * from <TableName>;
        or
(2)select * from public.<TableName>;
 
 on the query tool to access any table inside the public schema I got the following error:
ERROR:  relation "<TableName>" does not exist
                  or
ERROR:  relation "public.<TableName>" does not exist
thought I am logging in with a superuser account.
 
-Please advice.
 
Thanks,
Mohamed.

Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.

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