/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 vote224 views1 answer
Git cheat
Shell/Bash
0 vote179 views1 answer
Upgrade R kernel
Shell/Bash
5 votes170 views1 answer
Install flameshot
Shell/Bash
3 votes205 views2 answers
Gulp cli
Shell/Bash
2 votes181 views1 answer
Install blender fedora
Shell/Bash
5 votes196 views10 answers
Docker ps with ip
Shell/Bash
5 votes190 views2 answers
Install adonis cli
Shell/Bash
0 vote208 views1 answer
Run dotnet core app
Shell/Bash
0 vote234 views1 answer
Print(" Menghitung Luas bangun datar Persegi, Segitiga dan Lingkaran") s = float(input("Input sisi persegi: ")) luas = s**2 print("\nLuas Persegi\t\t:", luas)
Shell/Bash
2 votes176 views2 answers
Change sshd config
Shell/Bash