inspect_sequences
Compare database sequences against table column maxima to detect when sequences need resetting after bulk imports or manual inserts.
Instructions
Compare serial/identity sequences to MAX(column). needs_reset is true when the table is ahead of the sequence (typical after a dump or manual INSERT).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | Connection name or id | |
| table | No | Only this table | |
| schema | No | Schema (default: connection schema or public) |