| From: | mattk <mksql(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Unformatted view DDL in pg_dump |
| Date: | 2013-05-01 02:22:32 |
| Message-ID: | 1367374951958-5753856.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yang Zhang | 2013-05-01 02:27:09 | Re: OK to put temp tablespace on volatile storage or to omit it from backups? |
| Previous Message | Ian Lawrence Barwick | 2013-05-01 02:14:25 | Re: OK to put temp tablespace on volatile storage or to omit it from backups? |