Re: How to get schema name in which TEMPORARY table is created? - Mailing list pgsql-admin

From Gnanakumar
Subject Re: How to get schema name in which TEMPORARY table is created?
Date
Msg-id 001c01cbde14$7ac51680$704f4380$@com
Whole thread Raw
In response to Re: How to get schema name in which TEMPORARY table is created?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
>> How do I get the schema name in which TEMPORARY table is created using
>> "CREATE TEMP TABLE mytable ...." syntax?

> Do you need the real schema name, or will the "pg_temp" alias be
> sufficient?

I need the real schema name (for example, pg_temp_xxx) in which it is
created and not just the alias.


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to get schema name in which TEMPORARY table is created?
Next
From: Christian Ullrich
Date:
Subject: Re: How to get schema name in which TEMPORARY table is created?