Catalog

Sequences & identity

Name: Nexoxa Bridge
Author: Nexoxa

Serial columns and sequence last-value state.

The story

These pages use illustrative scenarios to walk through real workbench panels. Sidebar labels, Bridge paths, and connection schemes match the app; characters and timelines are examples for learning.

After bad import, ids collide, opens Sequences — serial columns and last values — and advances sequence without guessing nextval.

The Catalog panel Sequences is where Bridge turns raw metadata into decisions — counts, definitions, dependencies, and links into the grid or Query lab. No information_schema archaeology; no guessing which mat view is stale.

Open Sequences from the left sidebar after you connect; everything here reflects the live connection, not a cached export from yesterday.

Bridge path: /database/sequences

Step 1

Last value and identity

users_id_seq behind max(id) — setval fix copied to Query lab.
Dependency on users table visible.

Serial columns and sequence last-value state. /database/sequences. Sequences and identity columns.

Step 2

Advance safely

Advance after bulk import; verify next insert in grid.
No duplicate key violations in prod.

SQL helpers for setval. Dependency visibility.

Step 3

Map serial to table

Which column uses which sequence — catalog answers without d users in psql.
Onboarding win.

Linked tables from metadata.

This panel appears in the Nexoxa Bridge left sidebar after you connect with the matching connection URL. See the connection docs above for postgresql://, ssh://, sftp://, s3://, or smtp:// examples.

Related connections

Database connection URLs