Kumi
28c25a27ca
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.
9 lines
446 B
Text
9 lines
446 B
Text
# 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.
|