Bruce Momjian wrote:

Thomas Swan wrote:

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.


Why delete just those?  I don't see a compelling usefulness.

You have to explicitly name all of them. Also, some of those are unnamed if they were auto created.

Also, the SERIAL datatype creates an auto_named sequence that's not always easy to figure out. And, dropping a table leaves that sequence still intact.

On the owner permissions front. If someone is developing and wants to wipe their database and start fresh, the easiest way is to do a drop database, and create database. But, that would require the createdatabase right. But, in a situation where multiple developers are working on different databases, this is awkward. The proposed request always a normal user to clean that database and start fresh, so to speak.