change owner psql on all tables code example

Example 1: postgresql db owner change

ALTER DATABASE target_database OWNER TO new_onwer;

Example 2: postgres alter table owner

ALTER TABLE <tablename> OWNER TO <username>