Re: pgsql: Improve pretty printing of viewdefs. - Mailing list pgsql-committers

From Andrew Dunstan
Subject Re: pgsql: Improve pretty printing of viewdefs.
Date
Msg-id 4F41670F.1000206@dunslane.net
Whole thread Raw
In response to Re: pgsql: Improve pretty printing of viewdefs.  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-committers
[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

pgsql-committers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: pgsql: Improve pretty printing of viewdefs.
Next
From: Tom Lane
Date:
Subject: pgsql: Create the beginnings of internals documentation for the regex c