pg_my_temp_schema

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

English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

group: info
group label: 系统信息函数和操作符
lang: en
layout: table-new
pages: functions-info.html
prose only: false

Definition PG 18

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

Signatures and overloads

pg_my_temp_schema () → oid → 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).

Compare versions

Complete source facts

documentation revision

{"inputs":[{"file":"functions-info.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"64499116227a087138bb14f29ff6652b200a176d5df3ce2a089c3d5c226b19b3","version":"18.7"},{"file":"functions-info.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"f9684137c0b9fb17a691c4d905529d114472a507a007c15058f2703962b611d2","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:99b7f626f369c2cf1e3626a186364c9d6178a2a7a78f8f64b0f855d5395168b7

Text language: en · wiki-repair-20261023:99b7f626f369c2cf1e3626a186364c9d6178a2a7a78f8f64b0f855d5395168b7