Re: trouble dropping a table

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: trouble dropping a table
Date: 2009-06-26 18:31:28
Message-ID: 4A44CDB00200002500027FC0@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu> wrote:

> Schema | Name | Type | Owner
> --------+---------------------+-------+-------
> public | gallo.plate_subject | table | ysu
> (1 row)
>
> and I want to get rid of this table.

How about?:

DROP TABLE public."gallo.plate_subject"

It looks like you have a dot in your table name, which would require
quotes like that.

-Kevin

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tena Sakai 2009-06-26 18:49:27 Re: trouble dropping a table
Previous Message Scott Marlowe 2009-06-26 18:21:22 Re: PHP cann't access to postgres databse