Update sequence query

update_sequence.sql

SELECT
    'select pg_catalog.setval(pg_get_serial_sequence('''||
        pg_class.relname || ''', ''' ||
        pg_attribute.attname || '''), (SELECT MAX(' || pg_attribute.attname || ') FROM ' ||
        pg_class.relname || ') +1 ); '
    FROM pg_index, pg_class, pg_attribute
    WHERE
      pg_class.oid = pg_class.relname::regclass AND
      indrelid = pg_class.oid AND
       pg_attribute.attrelid = pg_class.oid AND
       pg_attribute.attnum = any(pg_index.indkey) AND
       pg_class.relkind = 'r' and pg_class.relhaspkey
     AND indisprimary
    AND pg_class.relname LIKE '<table_name>'
;