Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 26 Jun 2009 13:31:28 -0500
- Message-id: <4A44CDB00200002500027FC0@gw.wicourts.gov> <text/plain>
"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
- Follow-Ups:
- Re: trouble dropping a table
- From: Tena Sakai
- Re: trouble dropping a table
- References:
- trouble dropping a table
- From: Tena Sakai
- trouble dropping a table
- Prev by Date: Re: PHP cann't access to postgres databse
- Next by Date: Re: trouble dropping a table
- Previous by thread: trouble dropping a table
- Next by thread: Re: trouble dropping a table
- Indexes: