On Tue, Apr 29, 2014 at 11:14 AM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Keith Fiske <ke...@omniti.com> writes: > > On Sun, Feb 3, 2013 at 4:06 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > >> Applied with corrections. > > > Was this ever committed into core? Apologies, I'm not very familiar with > > looking through the commit history of the source code and I don't see > > anything about this option or pretty-print outputs in the pg_dump/restore > > docs for 9.3. Had someone asking me about this feature for pg_extractor > > Yeah, if I say "applied" that means I committed it. Here's the commit > log entry: > > Author: Tom Lane <t...@sss.pgh.pa.us> > Branch: master Release: REL9_3_BR [62e666400] 2013-02-03 15:56:45 -0500 > > Perform line wrapping and indenting by default in ruleutils.c. > > This patch changes pg_get_viewdef() and allied functions so that > PRETTY_INDENT processing is always enabled. Per discussion, only the > PRETTY_PAREN processing (that is, stripping of "unnecessary" > parentheses) > poses any real forward-compatibility risk, so we may as well make dump > output look as nice as we safely can. > > Also, set the default wrap length to zero (i.e, wrap after each SELECT > or FROM list item), since there's no very principled argument for the > former default of 80-column wrapping, and most people seem to agree > this > way looks better. > > Marko Tiikkaja, reviewed by Jeevan Chalke, further hacking by Tom Lane > > As per the branch annotation, this is in 9.3 and up. > > regards, tom lane > Great! Thanks, Tom -- Keith Fiske Database Administrator OmniTI Computer Consulting, Inc. http://www.keithf4.com