> 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 <tgl@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