Re: [GENERAL] Unable to access table named "user"

2009-05-12 Thread Adrian Klaver
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 o

Re: [GENERAL] Unable to access table named "user"

2009-05-12 Thread Sam Mason
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 wi

Re: [GENERAL] Unable to access table named "user"

2009-05-12 Thread Joe Kramer
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 wrote: > On Tue, May 12, 2009 at 1:26 AM, Joe Kramer wrote: >> Hi, >> >> I have table named user (lower case) in public sch

Re: [GENERAL] Unable to access table named "user"

2009-05-12 Thread Scott Marlowe
On Tue, May 12, 2009 at 1:26 AM, Joe Kramer 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" -- Sent via pgsql-general mailing list (pgsq