postgres actualize pk seq code example

Example: update postgres sequence to max

SELECT setval('table_id_seq', (SELECT MAX(id) FROM table)+1);