Dick Davies <rasputnik(at)hellooperator(dot)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