Re: Show method of index

On May 19, 2009, at 11:31 AM, decibel <decibel(at)decibel(dot)org> wrote:

> On May 19, 2009, at 10:27 AM, Tom Lane wrote:
>> Robert Haas <robertmhaas(at)gmail(dot)com> writes:
>>> On May 19, 2009, at 10:02 AM, Greg Stark <greg(dot)stark(at)enterprisedb(dot)com
>>> >
>>> wrote:
>>>> One advantage of the current arrangement is that the constraints
>>>> and
>>>> triggers are almost (though not quite) in the same form as the
>>>> command to create them. It would be sad to lose that competely.
>>
>>> Agreed.
>>
>> +1 --- I *very* often find myself copying-and-pasting from \d output,
>> and the proposed tabular format would be a huge step backwards for
>> that. Personally I kinda wish that the column display were closer
>> to what CREATE TABLE wants ...
>
> Hmm.... what if we made the default to be all-tabular output, but
> had a different command that would spit out the SQL to re-create
> something?

How 'bout we flip that around? :-)

...Robert

>
>
> (I agree that the cut-and-paste ability is extremely handy and
> wouldn't want to remove it.)
> --
> Decibel!, aka Jim C. Nasby, Database Architect decibel(at)decibel(dot)org
> Give your computer some brain candy! www.distributed.net Team #1828
>
>