Обсуждение: Unable to access table named "user"

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.

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"

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

On Tue, May 12, 2009 at 06:57:07PM +1000, Joe Kramer wrote:
> Don't help either.
>
> Jdbc statement:
> SELECT * from "public"."user" ;
>
> Exception:
> ERROR: relation "public.user" does not exist

Are you sure the table exists or you're connecting to the correct
database then?  If you connect with psql and do "\dt" does it show up?

--
  Sam  http://samason.me.uk/

On Tuesday 12 May 2009 3:16:34 am Sam Mason wrote:
> On Tue, May 12, 2009 at 06:57:07PM +1000, Joe Kramer wrote:
> > Don't help either.
> >
> > Jdbc statement:
> > SELECT * from "public"."user" ;
> >
> > Exception:
> > ERROR: relation "public.user" does not exist
>
> Are you sure the table exists or you're connecting to the correct
> database then?  If you connect with psql and do "\dt" does it show up?
>
> --
>   Sam  http://samason.me.uk/

I would have to second Sam on this. If you find you are connected to the correct
database, does the JDBC driver allow you to select other tables or is the
problem restricted to this table?

--
Adrian Klaver
aklaver@comcast.net