[ADMIN] Can not access the public schema

[M.Khaled]

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.