Re: Feature Request: DROP ALL FROM DATABASE database_name

Thomas Swan <tswan-lst@ics.olemiss.edu> writes:
> This could be useful for cleaning out a database (sequences, triggers, 
> rules) without deleting it and without having to create it, thus 
> preserving permissions/owner information.

What permissions/owner information?  There won't be any left if we
remove everything in the database.

Also, given the possibility that the database has been created from
a nonempty template, it's less than clear exactly what should be
removed.

I'd say DROP and CREATE DATABASE is a perfectly presentable way of
handling this.
        regards, tom lane