Horton

Re: How to delete a table in Postgres ???

Jeff Self <jself@greatbridge.com>

View thread View on postgr.es
From: Jeff Self <jself@greatbridge.com>
To: suhail sarwar <sarwar@postmaster.co.uk>
Cc: <pgsql-novice@postgresql.org>
Date: 2001-04-27T21:11:21Z
Lists: pgsql-novice 
On Fri, 27 Apr 2001, suhail sarwar wrote:

> Does anyone know how to delete a table in postgresql???
>
DROP TABLE <tablename>

You also will need to drop the sequence if you plan to use the same table
name again.
 DROP SEQUENCE <sequencename>
You can find the sequence name by issuing the \d command in psql.
-- 
Jeff Self
Information Specialist
Great Bridge, LLC
www.greatbridge.com | www.greatbridge.org
Norfolk, VA
(757)233-5570
jeff.self@greatbridge.com