SELECT setval(pg_get_serial_sequence('table_name', 'id'), MAX(id)) FROM table_name;