Re: new psql \d command - Mailing list pgsql-hackers

From Andreas Pflug
Subject Re: new psql \d command
Date
Msg-id 3F3275E7.6070200@pse-consulting.de
Whole thread Raw
In response to Re: new psql \d command  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian wrote:

>Tom Lane wrote:
>  
>
>>Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
>>    
>>
>>>It might be a bit risky getting pg_dump to use it though?
>>>      
>>>
>>I definitely don't want pg_dump using the pretty-print stuff ;-).
>>I'm neutral on whether to use it in psql's \d commands.
>>    
>>
>
>I thought the pretty-printing stuff was designed specifically for psql
>\d and third-party apps like pgadmin.
>
Yes it was, but it can be meaningful for pg_dump too.
The pretty-print stuff will inflate the dump with many spaces which 
doesn't make any sense with formats not meant to be read by humans, 
(--format=c), but --format=p output might well be used for user editing. 
So IMHO an option to enable pretty-dump can be useful.

Regards,
Andreas



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: new psql \d command
Next
From: Andreas Pflug
Date:
Subject: Re: new psql \d command