Re: Show method of index - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Show method of index
Date
Msg-id E4B42A04-D399-4125-937C-1AEA60EF5F2D@gmail.com
Whole thread Raw
In response to Re: Show method of index  (decibel <decibel@decibel.org>)
Responses Re: Show method of index  (decibel <decibel@decibel.org>)
List pgsql-hackers
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
>
>


pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: Multiple sorts in a query
Next
From: Merlin Moncure
Date:
Subject: Re: Multiple sorts in a query