Re: sql command to drop everything

From: CoL <col(at)mportal(dot)hu>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: sql command to drop everything
Date: 2003-12-06 01:15:20
Message-ID: bqracg$2igu$2@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message hodges 2003-12-06 02:41:07 Re: Managing users
Previous Message CoL 2003-12-06 01:07:46 Re: Auto commit Off how will it effect us ?