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