Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > How about if we add a UNION that does: > > UNION > > SELECT 'non-local temp schemas skipped', NULL > > I think showing that would only be appropriate if we actually *did* skip > some. Finding that out would complicate the query unduly IMHO. > > > I see a few goals here: > > Prevent \dn from showing lots of lines for large installs > > Show the local temp schema so people can query it > > If those are agreed to be the goals then we end up with your original > solution (or a working implementation of same anyway). > > I'd like to see some input from other people about what they want...
I have added this to the TODO list: * Have psql \dn show only visible schemas using current_schemas() I know there was talk of showing all schemas only in admin mode, but I don't think we want to implement different behavior until we have a more practical reason to have such a mode distiction. Of course, \dn will have to be documented that is supresses non-visible schemas, and admins can always do a select from 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 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]