Answers for "alter table to new owner postgres"

SQL
1

how to change owner in postgres

ALTER DATABASE name OWNER TO new_owner;
Posted by: Guest on November-11-2020
1

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