how to drop table named user

From: "Patrick Hatcher" <PHatcher(at)macys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: how to drop table named user
Date: 2003-08-21 23:38:25
Message-ID: OF6103E215.DF3A001C-ON88256D89.0081960B-88256D89.00828120@fds.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2003-08-21 23:52:54 Re: how to drop table named user
Previous Message Jan Wieck 2003-08-21 22:46:20 Re: Buglist