Deze pagina is nog niet beschikbaar in uw eigen taal. We werken er hard aan om meer taalversies toe te voegen. Bedankt voor uw steun.

On this page

Show all

PG_PUBLICATION_TABLES

Updated on 2024-09-30 GMT+08:00

PG_PUBLICATION_TABLES displays the mapping between a publication and its published tables. Unlike the underlying system catalog PG_PUBLICATION_REL, this view expands the publications defined as FOR ALL TABLES and FOR ALL TABLES IN SCHEMA, in which each publishable table has a row. This view is supported only by clusters of version 8.2.0.100 or later.

Table 1 PG_PUBLICATION_TABLES columns

Name

Type

Description

pubname

name

Publication name

schemaname

name

Name of the schema of a table

tablename

name

Table name

Examples

Query all published tables.

1
2
3
4
5
6
SELECT * FROM PG_PUBLICATION_TABLES;
 pubname | schemaname | tablename 
---------+------------+-----------
 mypub   | public     | t1
 mypub   | public     | t2
(2 rows)
Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback