/Shell/Bash/Postgres alter owner of all tables

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

Postgres alter table owner

ALTER TABLE <tablename> OWNER TO <username>

Similar codes

0 vote315 views1 answer
Git delete remote branch error: unable to delete remote ref does not exist
Shell/Bash
2 votes272 views2 answers
Angular display block
Shell/Bash
3 votes399 views2 answers
Install packet tracer on ubuntu
Shell/Bash
5 votes262 views6 answers
E: Unable to acquire the dpkg frontend lock (/var/lib/dpkg/lock-frontend), are you root?
Shell/Bash
0 vote274 views2 answers
Ansible run tags
Shell/Bash
0 vote286 views1 answer
Oh-my-posh.psm1 porque la ejecución de scripts está deshabilitada en este sistema
Shell/Bash
0 vote290 views1 answer
How to count number of running processes in windows
Shell/Bash
0 vote279 views1 answer
Jekyll run
Shell/Bash
0 vote289 views1 answer
Troll someone
Shell/Bash
0 vote282 views1 answer
Apache2 ubuntu code exited
Shell/Bash