Many thanks, Scott and Kevin. Regards,
Tena Sakai tsa...@gallo.ucsf.edu -----Original Message----- From: Scott Whitney [swhit...@journyx.com] Sent: Fri 6/26/2009 11:26 AM Try: drop table "gallo.plate_subject" with the quotes. -----Original Message----- From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov] Sent: Fri 6/26/2009 11:31 AM To: Tena Sakai; pgsql-admin@postgresql.org Subject: Re: [ADMIN] trouble dropping a table "Tena Sakai" <tsa...@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
