Reset the pkeys of all tables in a postgres db

Reset the pkeys of all tables in a postgres db

DO
$$
DECLARE
    tbl   regclass;
    nbrow bigint;
BEGIN
   FOR tbl IN
      SELECT c.oid
      FROM   pg_class     c
      JOIN   pg_namespace n ON n.oid = c.relnamespace
      WHERE  c.relkind = 'r'
      AND    n.nspname NOT LIKE 'pg\_%'         -- system schema(s)
      AND    c.relname != 'password_resets'.    -- table without id column
      AND    n.nspname <> 'information_schema'  -- information schema
      ORDER  BY n.nspname, c.relname
   LOOP
	    EXECUTE 'SELECT setval(''' || tbl || '_id_seq'', (SELECT MAX(id) FROM ' || tbl || ')+1) ' INTO nbrow;
      -- raise notice '%: % rows', tbl, nbrow;
   END LOOP;
END
$$;