Postgres Pro
Downloads
Home   >   mailing lists

Re: trouble dropping a table - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: trouble dropping a table
Date
Msg-id 4A44CDB00200002500027FC0@gw.wicourts.gov
Whole thread Raw
In response to trouble dropping a table  ("Tena Sakai" <tsakai@gallo.ucsf.edu>)
List pgsql-admin
Tree view 
"Tena Sakai" <tsakai@gallo.ucsf.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

pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: PHP cann't access to postgres databse
Next
From: "Tena Sakai"
Date:
Subject: Re: trouble dropping a table