Answers for "make user owner of all tables postgres"

SQL

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

table user postgres

user is a reserved word in PostGreSQL
If you insist on using that name for tables then use "USER" with double quotes.
/*EXAMPLE*/
create table "user" (...);

Posted by: Guest on January-13-2022

Source

Code answers related to "make user owner of all tables postgres"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

Answers for "make user owner of all tables postgres"

Code answers related to "make user owner of all tables postgres"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us