Bruce Momjian <[EMAIL PROTECTED]> writes: > Also, how do we know something is a temp schema? Just the prefix > pg_temp_*?
Yeah. Remember that all schemas named pg_XXX are reserved for system use. For the moment, testing for pg_temp_XXX is a bulletproof test, and we can certainly adapt psql's test if we ever add schemas that might conflict. Looking at the present output of \dn, I wonder whether we should not suppress the pg_toast schema as well. That could be done (at the moment) by bouncing all schemas 'pg_t*' ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly