Re: empty a database - Mailing list pgsql-admin

From Tom Lane
Subject Re: empty a database
Date
Msg-id 12827.1108485117@sss.pgh.pa.us
Whole thread Raw
In response to empty a database  (Dick Davies <rasputnik@hellooperator.net>)
Responses Re: empty a database  (Dick Davies <rasputnik@hellooperator.net>)
List pgsql-admin
Dick Davies <rasputnik@hellooperator.net> writes:
> Is there a neat way to clean out a database via SQL commands?
> i.e. get rid of tables, sequences, integers, etc.

> At present I'm using dropdb/createdb, but thats' far from ideal
> and I think it's causing postgres to do more mork than it needs to...

Well, if you put everything into one or a few schemas then dropping
and recreating those schemas would do it.  I suspect though that this
is *not* faster than dropdb/createdb.

            regards, tom lane

pgsql-admin by date:

Previous
From: Dick Davies
Date:
Subject: empty a database
Next
From: Dick Davies
Date:
Subject: Re: empty a database