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

Поиск
Список
Период
Сортировка

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

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