Many thanks, Scott and Kevin. Regards,
Tena Sakai [email protected] -----Original Message----- From: Scott Whitney [[email protected]] Sent: Fri 6/26/2009 11:26 AM Try: drop table "gallo.plate_subject" with the quotes. -----Original Message----- From: Kevin Grittner [mailto:[email protected]] Sent: Fri 6/26/2009 11:31 AM To: Tena Sakai; [email protected] Subject: Re: [ADMIN] trouble dropping a table "Tena Sakai" <[email protected]> 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
