Re: Return value of CREATE TABLE

From: Christoph Moench-Tegeder <cmt(at)burggraben(dot)net>
To: Mike Martin <redtux1(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Return value of CREATE TABLE
Date: 2020-09-10 12:16:52
Message-ID: 20200910121652.GA25488@elch.exwg.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

## 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Martin 2020-09-10 12:36:33 Re: Return value of CREATE TABLE
Previous Message Nicolas Sornin 2020-09-10 12:13:55 PG13 partitioned table logical replication