patternsqlMinor
Where is `pg_temp` documented in the PG manual?
Viewed 0 times
thewheremanualpg_tempdocumented
Problem
I have tried various ways to search for
pg_temp in the manual, but could not find it. Is it documented in the manual?Solution
It is documented at https://www.postgresql.org/docs/current/static/runtime-config-client.html
Likewise, the current session's temporary-table schema, pg_temp_nnn, is always searched if it exists. It can be explicitly listed in the path by using the alias pg_temp. If it is not listed in the path then it is searched first (even before pg_catalog). However, the temporary schema is only searched for relation (table, view, sequence, etc) and data type names. It is never searched for function or operator names.
Likewise, the current session's temporary-table schema, pg_temp_nnn, is always searched if it exists. It can be explicitly listed in the path by using the alias pg_temp. If it is not listed in the path then it is searched first (even before pg_catalog). However, the temporary schema is only searched for relation (table, view, sequence, etc) and data type names. It is never searched for function or operator names.
Context
StackExchange Database Administrators Q#211081, answer score: 4
Revisions (0)
No revisions yet.