/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 vote200 views1 answer
Scp linux to mac
Shell/Bash
9 votes213 views1 answer
Npx react-native
Shell/Bash
-2 votes205 views1 answer
Instal maven in mac brew
Shell/Bash
26 votes204 views5 answers
Git stash untracked files
Shell/Bash
0 vote225 views1 answer
Anaconda install pyinstaller
Shell/Bash
4 votes195 views1 answer
Pm2 adonisjs
Shell/Bash
39 votes223 views6 answers
Scp from local to remote
Shell/Bash
0 vote250 views1 answer
Install composer ubuntu 16
Shell/Bash
2 votes213 views2 answers
Mongodb rename database
Shell/Bash
1 vote206 views1 answer
Gatsby.ps1 is not digitally signed
Shell/Bash