Обсуждение: Unformatted view DDL in pg_dump
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 parenthesis are present. Is this due to the way that view definitions are stored as metadata? And is this also why view definitions are not directly editable in psql as with \ef? (* wishing for an \ev *) -- View this message in context: http://postgresql.1045698.n5.nabble.com/Unformatted-view-DDL-in-pg-dump-tp5753856.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
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 the PostgreSQL - general mailing list archive at Nabble.com.