From: | Joe Kramer <cckramer(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Unable to access table named "user" |
Date: | 2009-05-12 07:26:32 |
Message-ID: | b4c00a110905120026y69808f7ekcb0489f6112cdf39@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-jdbc |
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;
I can't find any way to access this table from Jdbc.
Tried to access as public.user, user in single and double quotes, nothing helps.
I get exceptions like
ERROR: relation "public.user" does not exist
ERROR: relation "user" does not exist
Also tried to execute "SET search_path TO public" beforehand in same
jdbc connection, makes no difference.
Is there any way?
Thanks.
From | Date | Subject | |
---|---|---|---|
Next Message | Tomasz Rejman | 2009-05-12 07:30:12 | Selecting data from bytea field in 8.3 |
Previous Message | Peter Eisentraut | 2009-05-12 07:10:53 | Re: Compiler versions on different platforms |
From | Date | Subject | |
---|---|---|---|
Next Message | Luca Ferrari | 2009-05-12 07:39:07 | ResultSet internal data type handling |
Previous Message | Joe Kramer | 2009-05-12 07:19:32 | Unable to access table named "user" |