/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 vote152 views1 answer
How to install cargo crate
Shell/Bash
15 votes146 views2 answers
Git see stash
Shell/Bash
1 vote153 views1 answer
Ngrok with netcat
Shell/Bash
0 vote152 views1 answer
Cannot connect to daemon at tcp:5037: Connection refused
Shell/Bash
0 vote156 views1 answer
Error: pathspec 'new_brach' did not match any file(s) known to git
Shell/Bash
0 vote139 views1 answer
Two bash coomand in same line
Shell/Bash
0 vote160 views1 answer
Batch malware
Shell/Bash
0 vote135 views2 answers
Macos kill dns cache
Shell/Bash
0 vote146 views1 answer
Debian copy directory
Shell/Bash
-1 vote213 views2 answers
Wsl2 ubuntu
Shell/Bash