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
