postgres alter owner for db code example

Example 1: postgresql db owner change

ALTER DATABASE target_database OWNER TO new_onwer;

Example 2: how to change owner in postgres

ALTER DATABASE name OWNER TO new_owner;

Example 3: postgres alter table owner

ALTER TABLE <tablename> OWNER TO <username>