pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Can not access the public schema
2+ messages / 2 participants
[nested] [flat]

* Can not access the public schema
@ 2008-01-18 16:42 M.Khaled <mohamed_mohamed_186@yahoo.com>
  2008-01-18 17:54 ` Re: Can not access the public schema Carol Walter <walterc@indiana.edu>
  0 siblings, 1 reply; 2+ messages in thread

From: M.Khaled @ 2008-01-18 16:42 UTC (permalink / raw)
  To: 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.

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Can not access the public schema
  2008-01-18 16:42 Can not access the public schema M.Khaled <mohamed_mohamed_186@yahoo.com>
@ 2008-01-18 17:54 ` Carol Walter <walterc@indiana.edu>
  0 siblings, 0 replies; 2+ messages in thread

From: Carol Walter @ 2008-01-18 17:54 UTC (permalink / raw)
  To: M.Khaled <mohamed_mohamed_186@yahoo.com>; +Cc: pgsql-admin

I'm in an academic environment.  One of the problems that I often  
have, is that students will put upper case letters in table names.   
If this is done, and the student doesn't quote the table or column  
name this error is the result.  Is this possibly happening?

Carol
On Jan 18, 2008, at 11:42 AM, M.Khaled wrote:

> 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.

^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2008-01-18 17:54 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-01-18 16:42 Can not access the public schema M.Khaled <mohamed_mohamed_186@yahoo.com>
2008-01-18 17:54 ` Carol Walter <walterc@indiana.edu>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox