Re: pgsql: Improve pretty printing of viewdefs.

Hello

nice

should be this functionality used for query too?

some like

pg_pretty_query('SELECT ... ', 80)

when we have this functionality.

Regards

Pavel

2012/2/19 Andrew Dunstan <andrew(at)dunslane(dot)net>:
> Improve pretty printing of viewdefs.
>
> Some line feeds are added to target lists and from lists to make
> them more readable. By default they wrap at 80 columns if possible,
> but the wrap column is also selectable - if 0 it wraps after every
> item.
>
> Andrew Dunstan, reviewed by Hitoshi Harada.
>
> Branch
> ------
> master
>
> Details
> -------
> http://git.postgresql.org/pg/commitdiff/2f582f76b1945929ff07116cd4639747ce9bb8a1
>
> Modified Files
> --------------
> doc/src/sgml/func.sgml                     |   12 ++-
> src/backend/utils/adt/ruleutils.c          |  137 +++++++++++++++++++++++++++-
> src/include/catalog/catversion.h           |    2 +-
> src/include/catalog/pg_proc.h              |    2 +
> src/include/utils/builtins.h               |    1 +
> src/test/regress/expected/polymorphism.out |    4 +-
> src/test/regress/expected/rules.out        |   33 +++++++
> src/test/regress/expected/with.out         |   25 +++---
> src/test/regress/sql/rules.sql             |    6 +
> 9 files changed, 204 insertions(+), 18 deletions(-)
>
>
> --
> Sent via pgsql-committers mailing list (pgsql-committers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-committers