Hello,
I have created a temporary table using
create temporary table foo
(
id integer
);
and noticed this was created in a schema called "pg_temp_2"
My question is:
is this always "pg_temp_2"?
Or will the name of the "temp schema" change?
If it isn't always the same, is there a way I can retrieve the schema name for temporary tables?
Regards
Thomas