Modifying auto increments [til/data]

When using postgres locally for development, sometimes, if the production dataset is too large, I'll take a sample to work with locally. More recently I've run into the problem that when I load new production data into tables with auto increment primary key columns, I'll get a conflict, i.e. I load some production data in locally, and then when the auto increment runs it'll hit a conflict - because my local sequences are completely out of sync with production. The solution is to update my local ...

Submit