PostgreSQL Sync Sequence for Duplicate Key Error

postgresql-sync-sequence.sql

# For Single Table

SELECT setval('public."upload_file_morph_id_seq"',
  (SELECT MAX(id) FROM public.upload_file_morph)
);


# For All Tables

DO $$
DECLARE
i TEXT;
BEGIN
  FOR i IN (SELECT tbls.table_name FROM information_schema.tables AS tbls INNER JOIN information_schema.columns AS cols ON tbls.table_name = cols.table_name WHERE tbls.table_catalog='YOUR_DATABASE_NAME' AND tbls.table_schema='public' AND cols.column_name='id') LOOP
      EXECUTE 'SELECT setval(''"' || i || '_id_seq"'', (SELECT MAX(id) FROM ' || quote_ident(i) || '));';
  END LOOP;
END $$;