Re: Unable to access table named "user" - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Unable to access table named "user"
Date
Msg-id 200905120659.16676.aklaver@comcast.net
Whole thread Raw
In response to Re: Unable to access table named "user"  (Sam Mason <sam@samason.me.uk>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Andrew Gould
Date:
Subject: Re: Putting many related fields as an array
Next
From: "Francisco Figueiredo Jr."
Date:
Subject: Re: Difference between "in (...)" and "= any(...)" queries when using arrays