Re: Other formats in pset like markdown, rst, mediawiki

From: Jan Michálek <godzilalalala(at)gmail(dot)com>
To: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
Cc: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Other formats in pset like markdown, rst, mediawiki
Date: 2017-03-10 08:43:30
Message-ID: CAAYBy8YgpPGS-YWOecwB7m4qBzoBEQ_sqmQzpuCGyaOTZfN_RA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

2017-03-09 20:10 GMT+01:00 Peter Eisentraut <
peter(dot)eisentraut(at)2ndquadrant(dot)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 \x
>

I 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.

>
> - 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" directive
>

OK, 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: title
>
> I 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 day

Jan

>
> --
> Peter Eisentraut http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>

--
Jelen
Starší čeledín datovýho chlíva

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Rushabh Lathia 2017-03-10 08:53:47 Re: Gather Merge
Previous Message Thomas Munro 2017-03-10 08:36:04 Re: REINDEX CONCURRENTLY 2.0