Re: Return value of CREATE TABLE

From: Mike Martin <mike(at)redtux(dot)plus(dot)com>
To: Christoph Moench-Tegeder <cmt(at)burggraben(dot)net>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Return value of CREATE TABLE
Date: 2020-09-10 12:36:33
Message-ID: CAOwYNKb5qfwVZT1jCTczrOTjgpvj1EjDGbPyKFuagD3zuzEGbA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Philip Semanchuk 2020-09-10 13:05:04 Re: PKEY getting corrupted
Previous Message Christoph Moench-Tegeder 2020-09-10 12:16:52 Re: Return value of CREATE TABLE