Re: [HACKERS] Other formats in pset like markdown, rst, mediawiki - Mailing list pgsql-hackers
From | Jan Michálek |
---|---|
Subject | Re: [HACKERS] Other formats in pset like markdown, rst, mediawiki |
Date | |
Msg-id | CAAYBy8ZokHzHU12Ds+-t7myLPMH+VKoA9E8=tzBFCHNxcqOP=Q@mail.gmail.com Whole thread Raw |
In response to | Re: [HACKERS] Other formats in pset like markdown, rst, mediawiki (Jan Michálek <godzilalalala@gmail.com>) |
Responses |
Re: [HACKERS] Other formats in pset like markdown, rst, mediawiki
("Ideriha, Takeshi" <ideriha.takeshi@jp.fujitsu.com>)
|
List | pgsql-hackers |
2017-03-12 19:21 GMT+01:00 Jan Michálek <godzilalalala@gmail.com>:
In new diff is added \x for rst and skipping leading spaces in rst in both. make check passed
2017-03-10 9:43 GMT+01:00 Jan Michálek <godzilalalala@gmail.com>:2017-03-09 20:10 GMT+01:00 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>: This is looking pretty neat. I played around with it a bit. There are
a couple of edge cases that you need to address, I think.Thanks, original code is very synoptical and and well prepared for adding new formats.
- Does not support \xI know, i dnot`t know, if \x make sense in this case. I will look, how it is done in other formats like html. I think, that it should work in sense, that table generated to rst should give similar output after processing like output of html format.I prepared something like this (i have no prepared diff, i need do some another changes)There a few things I need to do. First problem is bold column names, i should do it in sme fashin as "RECORD", but i need to do some research about length of column.Bigger problem is with tab indent, rst processor doesn`t work with this in this case.
In new diff is added \x for rst and skipping leading spaces in rst in both. make check passed
Jan
jelen=# execute q \g | xclip
+---------+------------------------------------------------- -----------------------+
| **RECORD 1**|
+---------+------------------------------------------------- -----------------------+
| column1 | Elephant, kangaroo,|
| | squirrel, gorilla|
+---------+------------------------------------------------- -----------------------+
| column2 | 121|
+---------+------------------------------------------------- -----------------------+
| column3 | 1.0035971223021583|
+---------+------------------------------------------------- -----------------------+
| column4 | 0.1111|
+---------+------------------------------------------------- -----------------------+
| column5 | Hello Hello Hello Hello Hello Hello Hello Hello Hello Hello |
+---------+------------------------------------------------- -----------------------+
| **RECORD 2**|
+---------+------------------------------------------------- -----------------------+
| column1 | goat, rhinoceros,|
| | monkey, ape|
+---------+------------------------------------------------- -----------------------+
| column2 | 11121|
+---------+------------------------------------------------- -----------------------+
| column3 | 1.0007824726134585|
+---------+------------------------------------------------- -----------------------+
| column4 | 5.1111|
+---------+------------------------------------------------- -----------------------+
| column5 | xxxxxx xxxxxx xxxxxx xxxxxx xxxxxx xxxxxx xxxxxx xxxxxx xxxxxx xxxxxx |
+---------+------------------------------------------------- -----------------------+
| **RECORD 3**|
+---------+------------------------------------------------- -----------------------+
| column1 | donkey, cow, horse, tit,|
| | eagle, whale,|
| | aligator,|
| | pelican,|
| | grasshoper|
| | pig|
| | bat|
+---------+------------------------------------------------- -----------------------+
| column2 | 14351|
+---------+------------------------------------------------- -----------------------+
| column3 | 50.3877551020408163|
+---------+------------------------------------------------- -----------------------+
| column4 | 345.11|
+---------+------------------------------------------------- -----------------------+
| column5 | yyyyyy yyyyyy yyyyyy yyyyyy yyyyyy yyyyyy yyyyyy yyyyyy yyyyyy yyyyyy |
+---------+------------------------------------------------- -----------------------+
- When \pset format is rst, then \pset linestyle also shows up as
"rst". That is wrong. Same for markdown.I will look on this.
- Broken output in tuples_only (\t) mode. (rst and markdown)Similar to \x, im not certain, what it should return. I will look, what returns html format. Or i can use it in markdown for nice vs expanded format.
- rst: Do something about \pset title; the way it currently shows up
appears to be invalid; could use ".. table:: title" directiveOK, it shouldn`t be problem alter this.
- markdown: Extra blank line between table and footer.It is because markdown needs empty line after table, if is row count presented.
- markdown: We should document or comment somewhere exactly which of the
various markdown table formats this is supposed to produce. (Pandoc
pipe_tables?)I use format that was similar to aligned format and ascii linestyle, because it allows me to use existing features. I should look over more table styles in markdown.
- markdown: Table title needs to be after the table, like
Table: titleI will change this.- markdown: Needs to escape | characters in cell contents. (Not
needed for rst.) More escaping might be needed.This can be problem because of aligning, i will look on this, this same problem as replace newline with </br> for markdown.Have Nice dayJan
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--JelenStarší čeledín datovýho chlíva
--JelenStarší čeledín datovýho chlíva
--
Jelen
Starší čeledín datovýho chlívaAttachment
pgsql-hackers by date: