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

Re: Can not access the public schema

From: Carol Walter <walterc(at)indiana(dot)edu>
To: "M(dot)Khaled" <mohamed_mohamed_186(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Can not access the public schema
Date: 2008-01-18 17:54:18
Message-ID: 9BCC6B68-7086-42AC-8D05-6B6C9CA4F50E@indiana.edu (view raw or flat)
Thread:
Lists: 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.

In response to

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2008-01-18 23:04:54
Subject: Re: update performance 8.1.4
Previous:From: M.KhaledDate: 2008-01-18 16:42:36
Subject: Can not access the public schema

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