↑↓ 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

current_schemas

Read the PG 18 manual

Returns an array of the names of all schemas presently in the effective search path, in their priority order.

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

Signatures & examples

current_schemas ( include_implicit boolean ) → name[]
Returns an array of the names of all schemas presently in the effective search path, in their priority order. (Items in the current search_path setting that do not correspond to existing, searchable schemas are omitted.) If the Boolean argument is true, then implicitly-searched system schemas such as pg_catalog are included in the result.
Version history 4
  1. 12 → 13 changed
  2. 8.3 → 8.4 changed
  3. 7.4 → 8.0 changed
  4. 7.2 → 7.3 added

Definition snapshot: b7bd9cda · English manual source