postgresql use max in update code example Example: update postgres sequence to max SELECT setval('table_id_seq', (SELECT MAX(id) FROM table)+1);