Re: how to drop table named user

From: <btober(at)seaworthysys(dot)com>
To: <PHatcher(at)macys(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: how to drop table named user
Date: 2003-08-22 00:15:44
Message-ID: 64995.66.212.203.144.1061511344.squirrel@$HOSTNAME
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.

I think maybe you could try enclosing the table name within double
quotation marks.

~Berend Tober

In response to

Browse pgsql-general by date

  From Date Subject
Next Message terry 2003-08-22 01:20:42 Re: 3 way outer join dilemma
Previous Message Ron Johnson 2003-08-22 00:10:41 Re: [HACKERS] [pgsql-advocacy] Need concrete "Why