Fix all tables sequences & ownership (Postgres)

fix-sequences.sql

CREATE OR REPLACE FUNCTION "reset_sequence" (tablename text, columnname text, sequence_name text)
    RETURNS "pg_catalog"."void" AS

    $body$
      DECLARE
      BEGIN

      EXECUTE 'SELECT setval( ''' || sequence_name  || ''', ' || '(SELECT MAX(' || columnname ||
          ') FROM ' || tablename || ')' || '+1)';

      EXECUTE 'ALTER SEQUENCE ' || sequence_name  || ' OWNED BY ' || tablename || '.' || columnname;

      END;

    $body$  LANGUAGE 'plpgsql';


SELECT table_name || '_' || column_name || '_seq',
    reset_sequence(table_name, column_name, table_name || '_' || column_name || '_seq')
FROM information_schema.columns where column_default like 'nextval%';