Cloud

pg_relation_is_publishable

Use the`pg_relation_is_publishable()` function to determine whether a specified relation (table) can be published in a publication.

Syntax

pg_relation_is_publishable(table_name_or_oid)

The function returns false for every existing table and NULL for any non-existing table.

Parameters

  • table_name_or_oid: Specifies the object identifier (OID) of a table or its name.

Examples

SELECT pg_relation_is_publishable('existing_table');
 pg_relation_is_publishable
----------------------------
 f
SELECT pg_relation_is_publishable(16386);
 pg_relation_is_publishable
----------------------------
 f