# pg_relation_is_publishable

> For the complete documentation index, see [llms.txt](https://docs.redpanda.com/llms.txt). Component-specific: [cloud-data-platform-full.txt](https://docs.redpanda.com/cloud-data-platform-full.txt)

---
title: pg_relation_is_publishable
latest-operator-version: v26.1.4
latest-console-tag: v3.7.3
latest-connect-version: 4.93.0
latest-redpanda-tag: v26.1.9
docname: sql/sql-functions/other-functions/pg-relation-is-publishable
page-component-name: cloud-data-platform
page-version: master
page-component-version: master
page-component-title: Cloud
page-relative-src-path: sql/sql-functions/other-functions/pg-relation-is-publishable.adoc
page-edit-url: https://github.com/redpanda-data/cloud-docs/edit/main/modules/reference/pages/sql/sql-functions/other-functions/pg-relation-is-publishable.adoc
description: Use the pg_relation_is_publishable() function to determine whether a specified relation (table) can be published in a publication.
page-topic-type: reference
page-git-created-date: "2026-05-26"
page-git-modified-date: "2026-05-26"
---

<!-- Source: https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-functions/other-functions/pg-relation-is-publishable.md -->

Use the\`pg\_relation\_is\_publishable()\` function to determine whether a specified relation (table) can be published in a [publication](https://www.postgresql.org/docs/current/logical-replication-publication.html).

## [](#syntax)Syntax

```sql
pg_relation_is_publishable(table_name_or_oid)
```

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

## [](#parameters)Parameters

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


## [](#examples)Examples

```sql
SELECT pg_relation_is_publishable('existing_table');
 pg_relation_is_publishable
----------------------------
 f
```

```sql
SELECT pg_relation_is_publishable(16386);
 pg_relation_is_publishable
----------------------------
 f
```