SELECT setval('TABLENAME_id_seq', (SELECT MAX(id) FROM "TABLENAME"));

-- Literally replace TABLENAME with your table name:
-- SELECT setval('foo_id_seq', (SELECT MAX(id) FROM "foo"));