Re: how to drop table named user - Mailing list pgsql-general

From
Subject Re: how to drop table named user
Date
Msg-id 64995.66.212.203.144.1061511344.squirrel@$HOSTNAME
Whole thread Raw
In response to how to drop table named user  ("Patrick Hatcher" <PHatcher@macys.com>)
List pgsql-general
> We accidentally created a table called user  in our public schema.  We
> are now trying to remove the table using DROP TABLE user and even DROP
> TABLE public.user.  However every time we try we get an error message:
> ERROR: parser: parse error at or near "user" at character 12
>
> Any suggestion on how to remove this table?  I thought maybe going
> through Pg Class, but I'm terrified of mucking something else up.

I think maybe you could try enclosing the table name within double
quotation marks.

~Berend Tober




pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: how to drop table named user
Next
From: Ron Johnson
Date:
Subject: Re: [HACKERS] [pgsql-advocacy] Need concrete "Why