/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

1 vote263 views1 answer
Install trading view on linux
Shell/Bash
0 vote267 views2 answers
How to install kite on manjero
Shell/Bash
0 vote291 views1 answer
Restart yabai fast
Shell/Bash
0 vote261 views1 answer
Install thefuck for ubuntu
Shell/Bash
1 vote282 views1 answer
Bash split and get last
Shell/Bash
0 vote273 views2 answers
Http-server
Shell/Bash
35 votes257 views6 answers
Git reset file
Shell/Bash
1 vote317 views1 answer
Installing freeswitch mod_spy using apt-get
Shell/Bash
0 vote260 views1 answer
Migrate mongodb to documentdb
Shell/Bash
28 votes271 views5 answers
Install vue cli 3
Shell/Bash