PostgreSQL: Administration as Non-Superuser
That can easily be done if you make your administrative user a member of the users you create:
CREATE ROLE newuser LOGIN;
GRANT newuser TO admin;

Then you inherit all rights from that user and can ALTER and DROP the objects it owns. You can even become that user:
SET ROLE newuser;

The only problem is that newuser can revoke that privilege.