Created these tables and sequences under
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?