Re: Unable to access table named "user"

From: Joe Kramer <cckramer(at)gmail(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Unable to access table named "user"
Date: 2009-05-12 08:57:07
Message-ID: b4c00a110905120157r5327a5f1l235c917b474bf6c4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

Don't help either.

Jdbc statement:
SELECT * from "public"."user" ;

Exception:
ERROR: relation "public.user" does not exist

On Tue, May 12, 2009 at 5:55 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> On Tue, May 12, 2009 at 1:26 AM, Joe Kramer <cckramer(at)gmail(dot)com> wrote:
>> Hi,
>>
>> I have table named user (lower case) in public schema.
>> I can access it using Pgadmin as
>> SELECT * from "user"; SELECT * from "public.user"; SELECT * FROM public.user;
>
> Try "public"."user"
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Markus Wollny 2009-05-12 10:04:58 Could not open file "pg_clog/...."
Previous Message Richard Huxton 2009-05-12 08:02:31 Re: Difference between "in (...)" and "= any(...)" queries when using arrays

Browse pgsql-jdbc by date

  From Date Subject
Next Message Luca Ferrari 2009-05-12 10:03:25 Re: ResultSet internal data type handling
Previous Message Oliver Jowett 2009-05-12 08:44:33 Re: ResultSet internal data type handling