WIP: pg_pretty_query

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема WIP: pg_pretty_query
Дата
Msg-id CAFj8pRCzqdx3MbHdexOAYgxSS3FYOOwfZ8Vx=Aw74fQb+PUA0A@mail.gmail.com
обсуждение исходный текст
Ответы Re: WIP: pg_pretty_query
Re: WIP: pg_pretty_query
Re: WIP: pg_pretty_query
Список pgsql-hackers
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)

Regards

Pavel

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: -Wformat-zero-length
Следующее
От: Thom Brown
Дата:
Сообщение: Re: WIP: pg_pretty_query