Postgre change ownership of whole database to the role/user (including tables, functions, and views)
If you need to transfer ownership of whole database (in postgress) you need to alter all tables, sequnces, views, and materialized views separately. Below is