Movatterモバイル変換


[0]ホーム

URL:



Facebook
Postgres Pro
Facebook
Downloads
52.17. pg_publication_tables
Prev UpChapter 52. System ViewsHome Next

52.17. pg_publication_tables#

The viewpg_publication_tables provides information about the mapping between publications and information of tables they contain. Unlike the underlying catalogpg_publication_rel, this view expands publications defined asFOR ALL TABLES andFOR TABLES IN SCHEMA, so for such publications there will be a row for each eligible table.

Table 52.17. pg_publication_tables Columns

Column Type

Description

pubnamename (referencespg_publication.pubname)

Name of publication

schemanamename (referencespg_namespace.nspname)

Name of schema containing table

tablenamename (referencespg_class.relname)

Name of table

attnamesname[] (referencespg_attribute.attname)

Names of table columns included in the publication. This contains all the columns of the table when the user didn't specify the column list for the table.

rowfiltertext

Expression for the table's publication qualifying condition



Prev Up Next
52.16. pg_prepared_xacts Home 52.18. pg_replication_origin_status
pdfepub
Go to Postgres Pro Standard 17
By continuing to browse this website, you agree to the use of cookies. Go toPrivacy Policy.

[8]ページ先頭

©2009-2025 Movatter.jp