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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
