Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Agreed showing just search path and implicit schemas is pretty dumb. I > > think the issue was that every backend with a temp table was showing up, > > pretty much swamping the actual schemas he is using. > > Oh, okay. I would not object to suppressing pg_temp_NNN schemas from > the \dn display. That isn't what this patch does, however.
OK. I read the TODO and it says only: * Have psql \dn show only visible schemas using current_schemas() so that's what I did, but I think now I have to add a test so only non-visible temp schemas are suppressed, and I think we have good logic for doing this because they really didn't create those schemas themselves --- the schemas are just an artifact of how we implement temp tables. Having one is fine, but having tons that obscure user-created schemas is probably bad. I will do that and repost. -- 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 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]