Alter postgresql sequence permission to the correct owner after migrate from mysql by py-mysql2pgsql

alter_seq.py

import psycopg2


def alter():
    conn = psycopg2.connect(database='bazaar4_13', user='postgres')
    cur = conn.cursor()
    
    seq_sql = """SELECT c.relname FROM pg_class c WHERE c.relkind = 'S'"""
    cur.execute(seq_sql)
    seq_list = cur.fetchall()
    
    for seq in seq_list:
        field = seq[0].rsplit('_', 2)[0]
        # print seq, field
        sql = 'ALTER SEQUENCE %s OWNED BY %s.id' % (seq[0], field)
        print sql
        cur.execute(sql)
        conn.commit()

    conn.close()


if __name__ == "__main__":
    alter()