I have a postgres table that contains data where the primary key has been set by the code that injected the data. So lets say the primary keys are 0..49.
How can I instruct postgres to start with 50 on the primary key column for the next insert? Currently all inserts without a set primary key cause duplicate ID issues since its starting from 0 (I assume).