View Single Post

   
  #1 (permalink)  
Old 04-10-2008, 08:18 AM
M.Khaled
 
Posts: n/a
Default Can not access the public schema

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.
Reply With Quote