"Patrick Hatcher" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
