Script to fix postgres migration issues with Laravel

postgres_laravel_fix.sql

DO $$
DECLARE
rec RECORD;
LAST_ID integer;
BEGIN
FOR rec IN SELECT
table_name
FROM information_schema.columns WHERE table_schema='public' and column_name='id' and data_type='integer'
LOOP
execute 'SELECT (id + 1) as id FROM ' || rec.table_name || ' ORDER BY id DESC LIMIT 1' into LAST_ID;
execute 'ALTER SEQUENCE public.' || rec.table_name || '_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 RESTART ' || COALESCE(LAST_ID, 1) || ' CACHE 1 NO CYCLE;';
END LOOP;
END; $$