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