SQL

postgresql db owner change

        
            
        
     ALTER DATABASE target_database OWNER TO new_onwer;

how to change owner in postgres

ALTER DATABASE name OWNER TO new_owner;

postgres alter table owner

ALTER TABLE <tablename> OWNER TO <username>

postgres alter owner of all tables

#TABLES
for tbl in `psql -qAt -c "select tablename from pg_tables where schemaname = 'public';" YOUR_DB` ; do  psql -c "alter table "$tbl" owner to NEW_OWNER" YOUR_DB ; done

#SEQUENCES
for tbl in `psql -qAt -c "select sequence_name from information_schema.sequences where sequence_schema = 'public';" YOUR_DB` ; do  psql -c "alter sequence "$tbl" owner to NEW_OWNER" YOUR_DB ; done

#VIEWS
for tbl in `psql -qAt -c "select table_name from information_schema.views where table_schema = 'public';" YOUR_DB` ; do  psql -c "alter view "$tbl" owner to NEW_OWNER" YOUR_DB ; done

postgresql set owner of table

ALTER TABLE "schemaname"."tablename" OWNER TO role_name;

Alter owner in PostgreSQL

pg_dump -Fp -f dbbackup.dmp <dbname>
vi dbbackup.dmp
:%s/oldowner/newowner/g
save and exit