Re: [GENERAL] Unformatted view DDL in pg_dump

2013-04-30 Thread mattk
I should add that I am extracting DDL with "pg_dump -s", and the output of \dv+ is nicely formatted without the extra parenthesis seen in the pg_dump output. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Unformatted-view-DDL-in-pg-dump-tp5753856p5753858.html Sent from

[GENERAL] Unformatted view DDL in pg_dump

2013-04-30 Thread mattk
When extracting DDL from a database, I note that the SQL for views is extracted as a single line, not with the line spacing and indenting it was created with. DbAdmin reformats the view, but other tools like DbVisualizer have SQL formatting rules that don't reformat nicely - a lot of extra parenthe