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