Re: printing table in asciidoc with psql - Mailing list pgsql-hackers

From Szymon Guz
Subject Re: printing table in asciidoc with psql
Date
Msg-id CAFjNrYs49sP5cLyPUeRdbjDPu-E7csvzk7XKMun8xNxkPiX-Pg@mail.gmail.com
Whole thread Raw
In response to Re: printing table in asciidoc with psql  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: printing table in asciidoc with psql
List pgsql-hackers


On 17 October 2014 09:01, Pavel Stehule <pavel.stehule@gmail.com> wrote:
Hi Szymon

I found a small bug - it doesn't escape "|" well

postgres=# select * from mytab ;
    a     | numeric_b |     c     
----------+-----------+------------
 Ahoj     |        10 | 2014-10-17
 Hello    |        20 | 2014-10-18
 Hi       |        30 | 2014-10-19
 aaa|aaaa |      2222 | 2014-10-17
(4 rows)


result

[options="header",cols="<literal,>literal,<literal",frame="all",grid="all"]
|====
^| +++a+++ ^| +++numeric_b+++ ^| +++c+++
| Ahoj | 10 | 2014-10-17
| Hello | 20 | 2014-10-18
| Hi | 30 | 2014-10-19
| aaa|aaaa | 2222 | 2014-10-17
|====


Next, I tested it with asciidoc and asciidoctor and I have a problem with asciidoctor - it doesn't respect aligning .. so numbers are aligned to left instead to right.

When you use a option "header" then a formatting "+++xxxx++++" is useless.

Hi Pavel,
thanks for the remarks. I've attached another version of the pach. It works a little better now, including escaping | and asciidoctor alignment support.

thanks,
Szymon
Attachment

pgsql-hackers by date:

Previous
From: "Tomas Vondra"
Date:
Subject: Re: WIP: multivariate statistics / proof of concept
Next
From: Petr Jelinek
Date:
Subject: Re: WIP: multivariate statistics / proof of concept