Sample Header Ad - 728x90

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