"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