Tom Lane wrote: > 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*' ...
Yea, probably. I think the "implementation artifact" logic is a good approach. If someone wants to get into implementation details, they should query pg_namespace. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
