/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

4 votes183 views1 answer
Ubuntu ifconfig get only ip address
Shell/Bash
0 vote183 views1 answer
Errno::EPERM: Operation not permitted @ dir_s_mkdir - /usr/local/Cellar
Shell/Bash
18 votes194 views4 answers
How to delete all branches in git local
Shell/Bash
2 votes322 views1 answer
Unable to install deno in ubuntu
Shell/Bash
8 votes274 views4 answers
Portainer install
Shell/Bash
2 votes197 views2 answers
How to verify if pip installed a package
Shell/Bash
0 vote231 views1 answer
Grep capture group
Shell/Bash
1 vote211 views1 answer
Count lines in files
Shell/Bash
10 votes225 views3 answers
Mount file to volume docker
Shell/Bash
9 votes181 views6 answers
Bash
Shell/Bash