Postgres Reset Sequence Function

reset_sequence.sql

CREATE OR REPLACE FUNCTION reset_sequence(tablename text) RETURNS "pg_catalog"."void" AS $$
DECLARE
BEGIN
	RAISE NOTICE 'Resetting sequence for %...', tablename;

	EXECUTE 'SELECT setval(''' || tablename || '_id_seq'', (SELECT MAX(id) FROM ' || tablename || '))';

	RAISE NOTICE 'Sequence reset.';

END;

$$ LANGUAGE plpgsql;