From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: psql: Add setting to make '+' on \d implicit |
Date: | 2010-04-23 18:28:38 |
Message-ID: | 13372.1272047318@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
"Ross J. Reedstrom" <reedstrm(at)rice(dot)edu> writes:
> On Fri, Apr 23, 2010 at 10:58:40AM -0500, Terry Brown wrote:
>> So the proposal would be:
>>
>> \d+ does as it has always done, no change
>> \d- (new) always behaves like 'old' \d
>> \d acts as 'old' \d or as \d+, depending on the setting of 'verbose_describe', set via \pset.
> Hmm, what about all the other + variants? Would this setting affect
> them? I'd suggest perhaps it should.
If we were to do something like that, it would certainly have to affect
every \d variant that has a + option. Which is probably not a very good
idea --- in many cases that's a very expensive/verbose option. I can't
get excited about this proposal, personally.
What the OP actually seemed to care about was database object comments.
I could see somebody who relied heavily on comments wanting his comments
to be included in all display commands, even without the + option.
Maybe a configuration variable along the lines of 'always_show_comments'
would be a better design.
BTW, \pset seems like the wrong place for this. That's for formatting
table output, not for controlling what specific \d commands show.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-04-23 18:36:12 | Re: recovery_connections cannot start (was Re: master in standby mode croaks) |
Previous Message | Marko Kreen | 2010-04-23 18:22:55 | Re: testing HS/SR - 1 vs 2 performance |