Re: pg_dump --pretty-print-views - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: pg_dump --pretty-print-views
Date
Msg-id 20130110142142.GV16126@tamriel.snowman.net
Whole thread Raw
In response to Re: pg_dump --pretty-print-views  (David Fetter <david@fetter.org>)
List pgsql-hackers
* David Fetter (david@fetter.org) wrote:
> On Thu, Jan 10, 2013 at 01:23:10PM +0100, Marko Tiikkaja wrote:
> > Any feedback is welcome.
>
> Why not make this the new default?  That way, new users will have the
> benefit, and people with tools or processes that depend on the old
> behavior can still have it.

I tend to agree with this, I've never really liked having the view def
all on one massive line.

Well, I'll caveat that with this- being able to grep -C2 and pull the
views and the view definitions has been nice on occation, but you can
pull independent objects out with pg_restore from a -Fc dump and, in
general, I think the advantage of having the view definition look
reasonable in the dump is more than being able to do tricks on views
(but not tables, etc anyway..) with grep.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Index build temp files
Next
From: Andrew Dunstan
Date:
Subject: Re: pg_dump --pretty-print-views