pg_relation_is_publishable()

Overview

Thepg_relation_is_publishable() function is used to determine whether a specified relation (table) can be published in a publication.

Syntax

The syntax for the pg_relation_is_publishable() function is as follows:

pg_relation_is_publishable(table_name_or_oid)

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

Parameters

The following parameters are required to execute this function:

• table_name_or_oid: specifies the object identifier (OID) of a table or it’s 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