how to drop table named user - Mailing list pgsql-general

From Patrick Hatcher
Subject how to drop table named user
Date
Msg-id OF6103E215.DF3A001C-ON88256D89.0081960B-88256D89.00828120@fds.com
Whole thread Raw
Responses Re: how to drop table named user  (<btober@seaworthysys.com>)
List pgsql-general
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

Patrick Hatcher



pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Buglist
Next
From: Doug McNaught
Date:
Subject: Re: how to drop table named user