Re: Show method of index

On May 19, 2009, at 11:31 AM, decibel <decibel@decibel.org> wrote:

> On May 19, 2009, at 10:27 AM, Tom Lane wrote:
>> Robert Haas <robertmhaas@gmail.com> writes:
>>> On May 19, 2009, at 10:02 AM, Greg Stark <greg.stark@enterprisedb.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@decibel.org
> Give your computer some brain candy! www.distributed.net Team #1828
>
>