Can not access the public schema

["M.Khaled" <mohamed_mohamed_186@xxxxxxxxx>]

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.