Resetting Auto-Incrementing IDs in PostgreSQL

console.sql

DO
$$
DECLARE
    rec RECORD;
    lastId INT;
BEGIN
    FOR rec IN (SELECT table_name
                FROM information_schema.tables
                WHERE table_schema = (SELECT current_schema())
                  AND table_type = 'BASE TABLE')
    LOOP
        RAISE NOTICE 'Processing table: %', rec.table_name;
        BEGIN
            EXECUTE 'SELECT COALESCE(MAX(id), 0) FROM ' || rec.table_name INTO lastId;
            EXECUTE 'ALTER SEQUENCE ' || rec.table_name || '_id_seq RESTART WITH ' || (lastId + 1);
        EXCEPTION
            WHEN others THEN
                RAISE NOTICE 'Error occurred for table %: %', rec.table_name, SQLERRM;
        END;
    END LOOP;
END;
$$;