Postgres Pro
Downloads
Home   >   mailing lists

Re: How to delete a table in Postgres ??? - Mailing list pgsql-novice

From Jeff Self
Subject Re: How to delete a table in Postgres ???
Date
Msg-id Pine.LNX.4.33.0104271707390.1126-100000@jselfpc.us.greatbridge.com
Whole thread Raw
In response to How to delete a table in Postgres ???  ("suhail sarwar" <sarwar@postmaster.co.uk>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: "Stephen M. Ford"
Date:
Subject: last install question (I hope)
Next
From: tompoe
Date:
Subject: install question