Thanks , exactly what I was looking for
On Thu, 10 Sep 2020 at 13:16, Christoph Moench-Tegeder <cmt@xxxxxxxxxxxxxx> wrote:
## Mike Martin (redtux1@xxxxxxxxx):
> So basically I would like to be able to know what namespace a temp table is
> created in, so that I can constrain lookup.
pg_my_temp_schema() returns the OID of the session's temporary schema
("or 0 if none", according to the docs).
Regards,
Christoph
--
Spare Space
