Change owner of everything in PostgreSQL
There are a lot of tips out there for changing the owner of tables and sequences and views in PostgreSQL. This can often be needed when you are reworking a project or changing the structure of your database.
Most of these suggestions center around doing SELECT statements of internal tables in PostgreSQL. That works, but this is much simpler:
REASSIGN OWNED BY old_owner TO new_owner;