Sean Chittenden wrote: > > > > If you want to suppress *all* pg_temp_ schemas from the \dn listing, > > that would be defensible maybe. I'd be inclined to say that > > pg_toast should be hidden as well if that approach is taken, because > > then you are basically saying that \dn is not the truth but only the > > stuff we think you should be interested in. (This is why I don't > > agree with it.) > > Um, I forget whether or not this was given any credence or anyone > weighed in on it, but what about having two modes for psql? An admin > mode which hides nothing and is the default for superuser connections, > and a user mode which is the default for non-DBA connections. Then we > could pretty easily rationalize hiding various schemas as they may or > may not be relevant. In the case where a normal user would want their > \command to show admin tables, schemas, etc., they could \set > ADMIN_MODE or toggle it on/off with a \command like \P. > > I've got the psql foo to pull this off pretty easily, but don't > recall a thumbsup/down on the idea. -sc
I would like to see a big reason before making psql behave differently for different people/modes. -- 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
