Re: How to get schema name in which TEMPORARY table is created?

From: Jens Wilke <jens(dot)wilke(at)affinitas(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to get schema name in which TEMPORARY table is created?
Date: 2011-03-08 14:18:34
Message-ID: 201103081518.34461.jens.wilke@affinitas.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tuesday 08 March 2011 15:02:57 Gnanakumar wrote:

Hi,

> How do I get the schema name in which TEMPORARY table is created using
> "CREATE TEMP TABLE mytable ...." syntax?

select n.nspname from pg_class c join pg_namespace n on n.oid=c.relnamespace
where c.relname ='foo' and n.nspname like 'pg_temp%';

Regards Jens

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Gnanakumar 2011-03-08 14:43:43 Re: How to get schema name in which TEMPORARY table is created?
Previous Message Gnanakumar 2011-03-08 14:02:57 How to get schema name in which TEMPORARY table is created?