Postgres Pro
Downloads
Home   >   mailing lists

Re: Return value of CREATE TABLE - Mailing list pgsql-general

From Christoph Moench-Tegeder
Subject Re: Return value of CREATE TABLE
Date
Msg-id 20200910121652.GA25488@elch.exwg.net
Whole thread Raw
In response to Return value of CREATE TABLE  (Mike Martin <redtux1@gmail.com>)
Responses Re: Return value of CREATE TABLE  (Mike Martin <mike@redtux.plus.com>)
List pgsql-general
Tree view 
## Mike Martin (redtux1@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

pgsql-general by date:

Previous
From: Nicolas Sornin
Date:
Subject: PG13 partitioned table logical replication
Next
From: Mike Martin
Date:
Subject: Re: Return value of CREATE TABLE