Cloud

pg_table_is_visible

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

pg_table_is_visible(table_or_index_oid)

Parameters

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

Examples

SELECT pg_table_is_visible(-1);
 pg_table_is_visible
----------------------------
 f
SELECT pg_table_is_visible(16386);
 pg_table_is_visible
----------------------------
 t
SELECT pg_table_is_visible(16381);
 pg_table_is_visible
----------------------------
 f