Contents
pg_my_temp_schema()
A function returning the OID of the session's temporary schema
pg_my_temp_schema() is a system function returning the OID of the session's temporary schema, if one exists.
pg_my_temp_schema() was added in PostgreSQL 8.2.
Usage
pg_my_temp_schema () → oid
If no temporary schema exists in the session, 0 is returned.
Change history
- PostgreSQL 8.2
- added (commit 65ab9f4f)
Examples
Basic usage example for pg_my_temp_schema():
postgres=# SELECT pg_my_temp_schema(); -- no temporary schema exist yet in this session
pg_my_temp_schema
-------------------
0
(1 row)
postgres=# CREATE TEMPORARY TABLE foo (id INT);
CREATE TABLE
postgres=# SELECT pg_my_temp_schema();
pg_my_temp_schema
-------------------
24608
(1 row)
References
- PostgreSQL documentation: Session Information Functions