Re: How to get schema name in which TEMPORARY table is created? - Mailing list 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