Thanks , exactly what I was looking for
On Thu, 10 Sep 2020 at 13:16, Christoph Moench-Tegeder <cmt(at)burggraben(dot)net>
wrote:
> ## Mike Martin (redtux1(at)gmail(dot)com):
>
> > 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
>