PrivateCoffee/postgres-sequence-fixer
4
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity
No description
1 commit 1 branch 0 tags 29 KiB
SQL 100%
Find a file
Kumi 28c25a27ca
Add script and README for sequence adjustment in PostgreSQL 
Introduced a SQL script with accompanying documentation that corrects sequence values in PostgreSQL databases following data import. The script dynamically adjusts sequence numbers to align with the maximum values present in their respective tables, addressing issues that can occur when sequences fall out of sync after bulk inserts or imports. Use caution as provided without warranty.
2023-12-28 10:33:15 +01:00
fix.sql Add script and README for sequence adjustment in PostgreSQL 2023-12-28 10:33:15 +01:00
README Add script and README for sequence adjustment in PostgreSQL 2023-12-28 10:33:15 +01:00

README 

# Sequence fixer for PostgreSQL

This is a simple SQL script that will ensure that sequences in a PostgreSQL database are set to the correct value, based on the maximum value of the corresponding column in the table.

Running this script is useful when you have imported data into a PostgreSQL database and the sequences are not set to the correct value.

## Disclaimer

This script is provided as-is, without any warranty. Use at your own risk.