Restart sequences after a migration

restart_sequences.sql

create or replace function restart_sequence(seq_name varchar) returns void language plpgsql as $func$
declare
  maxint bigint;
  table_name varchar;
begin
  table_name := left(seq_name, -7);
  execute 'select max(id) + 1 from '||table_name into maxint;
  if maxint is not null then
    execute 'alter sequence '||seq_name||' restart with '||cast(maxint as text);
  end if;
end;
$func$
;

select restart_sequence(cast(relname as text)) from pg_catalog.pg_statio_all_sequences where schemaname = 'public';