Fix postgres sequence after insert

SELECT 
    'SELECT SETVAL(' ||
       quote_literal(quote_ident(sequence_namespace.nspname) || '.' || quote_ident(class_sequence.relname)) ||
       ', COALESCE(MAX(' ||quote_ident(pg_attribute.attname)|| '), 1) ) FROM ' ||
       quote_ident(table_namespace.nspname)|| '.'||quote_ident(class_table.relname)|| ';'
FROM pg_depend 
    INNER JOIN pg_class AS class_sequence
        ON class_sequence.oid = pg_depend.objid 
            AND class_sequence.relkind = 'S'
    INNER JOIN pg_class AS class_table
        ON class_table.oid = pg_depend.refobjid
    INNER JOIN pg_attribute 
        ON pg_attribute.attrelid = class_table.oid
            AND pg_depend.refobjsubid = pg_attribute.attnum
    INNER JOIN pg_namespace as table_namespace
        ON table_namespace.oid = class_table.relnamespace
    INNER JOIN pg_namespace AS sequence_namespace
        ON sequence_namespace.oid = class_sequence.relnamespace
ORDER BY sequence_namespace.nspname, class_sequence.relname;

SELECT c.relname FROM pg_class c WHERE c.relkind = 'S' order BY c.relname;

SELECT 
concat('SELECT SETVAL(''public.', c.relname,''', COALESCE(MAX(id), 1) ) FROM public.', replace(c.relname, '_id_seq', ''), ';') FROM pg_class c WHERE c.relkind = 'S' order BY c.relname;

Alternative 2
SELECT table_name, column_name, seq,
       setval(seq, COALESCE(mx, 0) + 1, false) AS next_id
FROM (
  SELECT table_name, column_name,
         COALESCE(pg_get_serial_sequence(format('public.%I', table_name), column_name),
                  substring(column_default from 'nextval\(''([^'']+)''')) AS seq,
         (xpath('/row/m/text()',
                query_to_xml(format('select max(%I) as m from public.%I', column_name, table_name),
                             false, true, '')))[1]::text::bigint AS mx
  FROM information_schema.columns
  WHERE table_schema = 'public'
    AND (column_default LIKE 'nextval%' OR is_identity = 'YES')
) t;