Can not access the public schema - Mailing list pgsql-admin

From M.Khaled
Subject Can not access the public schema
Date
Msg-id 940440.58096.qm@web44807.mail.sp1.yahoo.com
Whole thread Raw
Responses Re: Can not access the public schema  (Carol Walter <walterc@indiana.edu>)
List pgsql-admin
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: more blob questions
Next
From: Carol Walter
Date:
Subject: Re: Can not access the public schema