Friday, April 15, 2016

PostgreSQL: get / set sequence value

Get latest sequence value:
select last_value from identity_id_seq;
Set sequence:
select setval('identity_id_seq', 2000041);