Re: [GENERAL] Unable to access table named "user" - Mailing list pgsql-jdbc

From Joe Kramer
Subject Re: [GENERAL] Unable to access table named "user"
Date
Msg-id b4c00a110905120157r5327a5f1l235c917b474bf6c4@mail.gmail.com
Whole thread Raw
List 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.marlowe@gmail.com> wrote:
> On Tue, May 12, 2009 at 1:26 AM, Joe Kramer <cckramer@gmail.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"
>

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: ResultSet internal data type handling
Next
From: Luca Ferrari
Date:
Subject: Re: ResultSet internal data type handling