* Gnanakumar wrote:
We're using PostgreSQL v8.2.3.How do I get the schema name in which TEMPORARY table is created using "CREATE TEMP TABLE mytable ...." syntax?
SELECT nspname FROM pg_namespace WHERE oid = pg_my_temp_schema(); I don't have an 8.2.3 lying around, but git says that function is in there. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
