Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group