↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Functions / System Information Functions And Operators

pg_table_is_visible

Read the PG 18 manual

Is table visible in search path? (This works for all types of relations, including views, materialized views, indexes, sequences and foreign tables.)

Reading PG 18current·documented in 25 of 27 versions, 7.3 to 20

Signatures & examples

pg_table_is_visible ( table oid ) → boolean
Is table visible in search path? (This works for all types of relations, including views, materialized views, indexes, sequences and foreign tables.)
Version history 4
  1. 12 → 13 changed
  2. 7.4 → 8.0 changed
  3. 7.3 → 7.4 changed
  4. 7.2 → 7.3 added

Definition snapshot: b7bd9cda · English manual source