> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])