Re: resetting sequence to cur max value

developer@wexwarez.com writes:
> Is there a way to set it up so it knows to skip past existing ids?

Usually you do something like

    select setval('seq_name', (select max(idcol) from table) + 1);

after loading data into the table.

            regards, tom lane