KB: How change the current value of a sequence

ALTER SEQUENCE "my_table_id_seq" RESTART WITH 5;

This will set the current value of sequence "my_table_id_seq" to 5.