pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCan 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>
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 17:54 Carol Walter <walterc@indiana.edu>
parent: M.Khaled <mohamed_mohamed_186@yahoo.com>
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