How to change table and sequence owner to another user with PostgreSQL?
3
votes
1
answer
12412
views
Created these tables and sequences under
postgres
user:
table creation schema
SET search_path TO main;
CREATE TABLE table1 ...
CREATE TABLE table2 ...
CREATE TABLE table3 ...
sequence creation schema
CREATE SEQUENCE main.seq1...
CREATE SEQUENCE main.seq2...
CREATE SEQUENCE main.seq3...
Now want to change all of them to an another owner named user1
. How to do without recreate these objects as they are been using?
Asked by Miantian
(177 rep)
Jun 28, 2021, 08:47 AM
Last activity: Jun 28, 2021, 12:08 PM
Last activity: Jun 28, 2021, 12:08 PM