psql update owner of all tables code example Example: postgres alter table owner ALTER TABLE <tablename> OWNER TO <username>