SELECT setval(pg_get_serial_sequence('the_table', 'pk_field'), coalesce(MAX(pk_field), 1))
from the_table;