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

From: Jeff Self <jself(at)greatbridge(dot)com>
To: suhail sarwar <sarwar(at)postmaster(dot)co(dot)uk>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: How to delete a table in Postgres ???
Date: 2001-04-27 21:11:21
Message-ID: Pine.LNX.4.33.0104271707390.1126-100000@jselfpc.us.greatbridge.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(dot)self(at)greatbridge(dot)com

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message tompoe 2001-04-28 03:05:22 install question
Previous Message Stephen M. Ford 2001-04-27 19:21:04 last install question (I hope)