Re: Unable to access table named "user"

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Unable to access table named "user"
Date: 2009-05-12 10:16:34
Message-ID: 20090512101634.GC22221@samason.me.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Glyn Astill 2009-05-12 10:33:18 Re: Could not open file "pg_clog/...."
Previous Message Sam Mason 2009-05-12 10:14:14 Re: Putting many related fields as an array

Browse pgsql-jdbc by date

  From Date Subject
Next Message Thomas Finneid 2009-05-12 13:24:51 pooled prepared statements
Previous Message Oliver Jowett 2009-05-12 10:09:12 Re: ResultSet internal data type handling