> 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%'; This will return all the schema name that are available which were created using TEMP TABLE syntax. Since our application is web-based, of course, there will be more than one schema name listed out of this query. My question is, how do I get the schema name of the temporary table immediately after calling "CREATE TEMP TABLE mytable ...." syntax? I need this schema name for one of my analysis purpose. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
