Re: how to drop table named user

"Patrick Hatcher" <PHatcher(at)macys(dot)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