postgres change owner to current user code example

Example: how to change owner in postgres

ALTER DATABASE name OWNER TO new_owner;