Re: WIP: pg_pretty_query - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: WIP: pg_pretty_query
Date
Msg-id 20120807155345.GM29773@momjian.us
Whole thread Raw
In response to WIP: pg_pretty_query  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: WIP: pg_pretty_query
List pgsql-hackers
On Tue, Aug  7, 2012 at 04:14:34PM +0200, Pavel Stehule wrote:
> Hello
> 
> last year we are spoke about reusing pretty print view code for some queries.
> 
> Here is patch:
> 
> this patch is really short - it is nice. But - it works only with
> known database objects (probably we would it) and it doesn't format
> subqueries well
> 
> 
> postgres=# select pg_pretty_query('select x.*, z.* from foo, foo x, x
> z  where x.a = 10 and x.a = 30 and EXISTS(SELECT * FROM foo WHERE a =
> z.a)', true, false);
>                      pg_pretty_query
> ----------------------------------------------------------
>   SELECT x.a, z.a                                        +
>     FROM foo, foo x, x z                                 +
>    WHERE x.a = 10 AND x.a = 30 AND (EXISTS ( SELECT foo.a+
>             FROM foo                                     +
>            WHERE foo.a = z.a))
> (1 row)

I can see this as very useful for people reporting badly-formatted
queries to our email lists.  Great!

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +


pgsql-hackers by date:

Previous
From: Jeff MacDonald
Date:
Subject: Re: [PATCH] Docs: Make notes on sequences and rollback more obvious
Next
From: Andrew Dunstan
Date:
Subject: Re: WIP: pg_pretty_query