Answers for "alter table to new owner postgres"

how to change owner in postgres

ALTER DATABASE name OWNER TO new_owner;

Posted by: Guest on November-11-2020

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

Posted by: Guest on July-08-2021

Code answers related to "alter table to new owner postgres"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "alter table to new owner postgres"

Code answers related to "alter table to new owner postgres"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "alter table to new owner postgres"

Code answers related to "alter table to new owner postgres"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us