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

Read the PG 18 manual

Returns the OID of the current session's temporary schema, or zero if it has none (because it has not created any temporary tables).

Reading PG 18current·documented in 21 of 27 versions, 8.2 to 20

7.17.27.37.48.08.18.28.38.49.09.19.29.39.49.59.61011121314151617181920

Signatures & examples

pg_my_temp_schema () → oid
Returns the OID of the current session's temporary schema, or zero if it has none (because it has not created any temporary tables).
Version history 2
  1. 12 → 13 changed
  2. 8.1 → 8.2 added

Definition snapshot: b7bd9cda · English manual source