| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
| Cc: | pgsql-committers(at)postgresql(dot)org |
| Subject: | Re: pgsql: Improve pretty printing of viewdefs. |
| Date: | 2012-02-19 21:18:07 |
| Message-ID: | 4F41670F.1000206@dunslane.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers pgsql-hackers |
[redirecting to -hackers]
On 02/19/2012 12:04 PM, Pavel Stehule wrote:
> Hello
>
> nice
>
> should be this functionality used for query too?
>
> some like
>
> pg_pretty_query('SELECT ... ', 80)
>
> when we have this functionality.
>
>
It would probably be possible to leverage some of this for that, but
it's certainly not part of the present piece of work. All the logic is
there in get_query_def() and friends. There would need to be a wrapper
that called the parser to get a query object from the input string and
then called get_query_def() to get back the reformatted output, and
there are probably any number of wrinkles I haven't thought of.
cheers
andrew
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2012-02-19 21:19:16 | Re: [COMMITTERS] pgsql: Improve pretty printing of viewdefs. |
| Previous Message | Pavel Stehule | 2012-02-19 17:04:53 | Re: pgsql: Improve pretty printing of viewdefs. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2012-02-19 21:19:16 | Re: [COMMITTERS] pgsql: Improve pretty printing of viewdefs. |
| Previous Message | Simon Riggs | 2012-02-19 21:11:56 | Re: Reducing bgwriter wakeups |