Thomas Swan <tswan-lst(at)ics(dot)olemiss(dot)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