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