pg_table_is_visible()

Overview

The pg_table_is_visible() is a schema visibility inquiry function that checks whether a specified table or other database object is visible in the current schema search path.

Syntax

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

pg_table_is_visible(table_or_index_oid)

Parameters

The following parameters are required to run this function:

• table_or_index_oid: specifies the object identifier (OID) of a table or it’s name

Examples

SELECT pg_table_is_visible(-1);
 pg_table_is_visible
----------------------------

SELECT pg_table_is_visible(16386);
 pg_table_is_visible
----------------------------
 t

SELECT pg_table_is_visible(16381);
 pg_table_is_visible
----------------------------
 f