Re: how to drop table named user

"Patrick Hatcher" <PHatcher@macys.com> writes:

> 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.
> TIA

DROP TABLE "user" should work.  The table name has to be quoted to
distinguish it from the USER SQL keyword.

-Doug