/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

3 votes359 views2 answers
Release a port in mac
Shell/Bash
0 vote331 views1 answer
Ubuntu deactivate shift+numpad = number
Shell/Bash
0 vote354 views2 answers
Count all files csv file in a directory linux
Shell/Bash
0 vote366 views1 answer
7.14 ES on linux installation
Shell/Bash
0 vote395 views1 answer
Node user installed packages
Shell/Bash
0 vote359 views4 answers
How to configure httpd in amazon ec2 instance
Shell/Bash
8 votes350 views1 answer
How to grep for file name recursively with some file content
Shell/Bash
0 vote371 views1 answer
Linux How to zip two files
Shell/Bash
4 votes362 views2 answers
Host key verification failed. fatal: Could not read from remote repository.
Shell/Bash
5 votes349 views1 answer
Download flutter through git
Shell/Bash