Re: printing table in asciidoc with psql
От | Pavel Stehule |
---|---|
Тема | Re: printing table in asciidoc with psql |
Дата | |
Msg-id | CAFj8pRChyBO7c5CXZxvw+vs+MULnXXi_CRj3J-Y9eXd+xL+rWA@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: printing table in asciidoc with psql (Szymon Guz <mabewlun@gmail.com>) |
Ответы |
Re: printing table in asciidoc with psql
|
Список | pgsql-hackers |
Hi Szymon
I found a small bug - it doesn't escape "|" wellpostgres=# 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)
[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
|====
When you use a option "header" then a formatting "+++xxxx++++" is useless.
2014-09-17 21:26 GMT+02:00 Szymon Guz <mabewlun@gmail.com>:
Hi,On 17 September 2014 19:55, Szymon Guz <mabewlun@gmail.com> wrote:On 17 September 2014 19:30, Peter Eisentraut <peter_e@gmx.net> wrote:On 9/16/14 3:52 PM, Szymon Guz wrote:
> It's not finished yet, I'm not sure it there is any sense in supporting
> border types etc.
AFAICT, Asciidoc doesn't support border types, so (if so) you should
just ignore that setting.Too late, I've done something like this:border=0
[frame="none",grid="none"]border=1
[frame="all",grid="none"]
border=2
[frame="all",grid="all"]thanks,
Szymonthanks for all the remarks.I've attached another version of this patch.I think it's done.- This works: `\pset format asciidoc`
- Output is formatted as asciidoc tables.
- There is support for borders {0,1,2}. The attached html file was made by running tests for psql, taking the asciidoc tables from it, converting to html with `asciidoc file`.-- border = 0 -> [frame="none",grid="none"]-- border = 1 -> [frame="none",grid="all"]-- border = 2 -> [frame="all",grid="all"]
- There are also tests.
-- For normal and extended mode combined with each of the border values.
-- With column names made of characters which need escaping
-- With values: (with escape needed characters, string '11' and integer 11 - they should have different right-left alignment).- Documentation for psql is updated.- According to Emanuel's advice: help.c is updated.
The attached html file contains tables from the test in this order:
normal, border 0
normal, border 1
normal, border 2
expanded, border 0
expanded, border 1
expanded, border 2regards,Szymon
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
В списке pgsql-hackers по дате отправления: