/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 vote180 views1 answer
How to install gnome kali
Shell/Bash
0 vote139 views1 answer
Installation Command
Shell/Bash
1 vote144 views1 answer
Force git to use ssh
Shell/Bash
0 vote149 views1 answer
How-to-remove-show-applications-icon-from-the-dock-in-ubuntu-20-04
Shell/Bash
0 vote155 views2 answers
Start powershell as different user
Shell/Bash
0 vote183 views1 answer
Clear port by terminal
Shell/Bash
0 vote152 views1 answer
Hugo serve
Shell/Bash
0 vote135 views1 answer
Writing login information to the keychain failed with error 'The name org.freedesktop.secrets was not provided by
Shell/Bash
0 vote142 views1 answer
Git accept incoming changes for all
Shell/Bash
1 vote140 views1 answer
Clean pendrive using diskpart
Shell/Bash