Can not access the public schema

From: "M(dot)Khaled" <mohamed_mohamed_186(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Can not access the public schema
Date: 2008-01-18 16:42:36
Message-ID: 940440.58096.qm@web44807.mail.sp1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Carol Walter 2008-01-18 17:54:18 Re: Can not access the public schema
Previous Message Tom Lane 2008-01-18 16:23:32 Re: more blob questions