pg_publication_sequences — PostgreSQL system view

Summary

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

(Description quoted from the official PostgreSQL documentation.)

Columns

The pg_publication_sequences system view exposes the following columns (names, types and descriptions are taken verbatim from the PostgreSQL documentation):

• pubname name references pg_publication.pubname
  Name of publication
• schemaname name references pg_namespace.nspname
  Name of schema containing sequence
• sequencename name references pg_class.relname
  Name of sequence

Related catalogs

This object references the following other system catalogs:

• pubname → pg_publication
• schemaname → pg_namespace
• sequencename → pg_class

Version applicability

Present in PostgreSQL 19 (verified against each release’s documentation). This object was introduced in PostgreSQL 19.

Related & references

• PostgreSQL system catalog & view index
• Built-in function reference

Reference: PostgreSQL documentation — pg_publication_sequences.