Re: Unable to access table named "user"

From: Adrian Klaver <aklaver(at)comcast(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: Sam Mason <sam(at)samason(dot)me(dot)uk>
Subject: Re: Unable to access table named "user"
Date: 2009-05-12 13:59:16
Message-ID: 200905120659.16676.aklaver@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

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(at)comcast(dot)net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Figueiredo Jr. 2009-05-12 15:27:15 Re: Difference between "in (...)" and "= any(...)" queries when using arrays
Previous Message Andrew Gould 2009-05-12 13:32:34 Re: Putting many related fields as an array

Browse pgsql-jdbc by date

  From Date Subject
Next Message The Jasper 2009-05-12 14:01:51 Enums - from java to jpa
Previous Message Thomas Finneid 2009-05-12 13:24:51 pooled prepared statements