Skip site navigation (1) Skip section navigation (2)

Re: pgsql: Improve pretty printing of viewdefs.

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 (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-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

In response to

Responses

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2012-02-19 21:19:16
Subject: Re: [COMMITTERS] pgsql: Improve pretty printing of viewdefs.
Previous:From: Simon RiggsDate: 2012-02-19 21:11:56
Subject: Re: Reducing bgwriter wakeups

pgsql-committers by date

Next:From: Andrew DunstanDate: 2012-02-19 21:19:16
Subject: Re: [COMMITTERS] pgsql: Improve pretty printing of viewdefs.
Previous:From: Pavel StehuleDate: 2012-02-19 17:04:53
Subject: Re: pgsql: Improve pretty printing of viewdefs.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group