Postgres Pro
Downloads
Home   >   mailing lists

Re: sql command to drop everything - Mailing list pgsql-novice

From CoL
Subject Re: sql command to drop everything
Date
Msg-id bqracg$2igu$2@news.hub.org
Whole thread Raw
In response to sql command to drop everything  (Bryan Irvine <bryan.irvine@kingcountyjournal.com>)
List pgsql-novice
Tree view 
Hi,

Bryan Irvine wrote, On 12/6/2003 2:04 AM:

> Is there a SQL command to delete everything (including the tables) from
> a db?  Not a complete drop so that the db doesn't exist anymore, but
> just so that there's nothing in it.

you can drop the schema.

drop schema NAME cascade;

C.

pgsql-novice by date:

Previous
From: "Taylor Lewick"
Date:
Subject: relationship/table design question
Next
From: epz
Date:
Subject: newbie needs help seting up for gentoo