select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

SYSTEM CATALOGS / SYSTEM VIEWS

pg_publication_sequences

Read PG 20 devel manual ↗

The view pg_publication_sequences provides information about the mapping between publications and sequences.

Development snapshot. These definitions may change before release.

Kind
System views
Columns in this snapshot
3
Definition source
English manual

Columns 3

ColumnTypeDescription / reference
pubnamenameName of publication
pg_publication.pubname
schemanamenameName of schema containing sequence
pg_namespace.nspname
sequencenamenameName of sequence
pg_class.relname
Column history across versions
Column9.09.19.29.39.49.59.61011121314151617181920
pubname················
schemaname················
sequencename················
Version history 1
  1. PG 18 → 19added

Definition snapshot: english-manuals:8b81b82f51c2a06c541a5b5ba09… · English manual source