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

If you want to implement a new table format, you should be looking at
\pset format, not \pset linestyle. \pset format sets different table
formats, such as html, latex, and asciidoc. \pset linestyle just
chooses between different styles for the plain-text table format.

On 3/1/17 06:31, Jan Michálek wrote:
> Regression test corrected.
>
> 2017-03-01 11:43 GMT+01:00 Jan Michálek <godzilalalala(at)gmail(dot)com
> <mailto:godzilalalala(at)gmail(dot)com>>:
>
> Sorry, I have some errors in my diff, i had copy something from bad
> folder. I will fix it.
>
> 2017-03-01 0:27 GMT+01:00 Jan Michálek <godzilalalala(at)gmail(dot)com
> <mailto:godzilalalala(at)gmail(dot)com>>:
>
> There it is, what i have.
> I need i small help with psql.out, because \pset format wrapped.
> I don`t know, how to have it in fixed width.
>
> 2017-02-28 14:23 GMT+01:00 Jan Michálek <godzilalalala(at)gmail(dot)com
> <mailto:godzilalalala(at)gmail(dot)com>>:
>
> Current state is something like this (diff is attached).
> I currently haven`t regression test, tab completion etc., I
> will add this thing following structure of asciidoc commit.
>
> Output is tested using retext, rst is OK, md have problem
> with cells with newline (i must find out, how it is possible
> create table with this in markdown).
>
> [jelen(at)laptak patch_postgre_rst]$
> [jelen(at)laptak psql]$ ./psql
> psql (9.6.2, server 9.6.1)
> Type "help" for help.
>
> jelen=# \pset linestyle markdown
> Line style is markdown.
> jelen=# values(E'nasral Franta\nna trabanta','Žluťoučký
> kobyly'), ('''',E'a\tb') \g | xclip
> jelen=# values(E'nasral Franta\nna trabanta','Žluťoučký
> kobyly'), ('''',E'a\tb') \g
>
> | column1 | column2 |
> |---------------|------------------|
> | nasral Franta | Žluťoučký kobyly |
> | na trabanta | |
> | ' | a b |
>
>
> (2 rows)
>
> jelen=# \pset linestyle rst
> Line style is rst.
> jelen=# values(E'nasral Franta\nna trabanta','Žluťoučký
> kobyly'), ('''',E'a\tb') \g
> +---------------+------------------+
> | column1 | column2 |
> +===============+==================+
> | nasral Franta+| Žluťoučký kobyly |
> | na trabanta | |
> +---------------+------------------+
> | ' | a b |
> +---------------+------------------+
>
> (2 rows)
>
> jelen=#
>
> 2017-02-24 0:46 GMT+01:00 Michael Paquier
> <michael(dot)paquier(at)gmail(dot)com <mailto:michael(dot)paquier(at)gmail(dot)com>>:
>
> On Fri, Feb 24, 2017 at 3:09 AM, Jan Michálek
> <godzilalalala(at)gmail(dot)com
> <mailto:godzilalalala(at)gmail(dot)com>> wrote:
> > I can try it, doesn`t look dificult, but I`m worry, that I`m not able to
> > write clean, pretty code.
>
> If you want to have something available in Postgres 10,
> you had better
> be quick. The last commit fest of the development cycle
> of Postgres 10
> begins on the 1st of March, you need to to register your
> patch here:
> https://commitfest.postgresql.org/13/
> <https://commitfest.postgresql.org/13/>
> Here are also some rough guidelines about submitting a
> patch:
> https://wiki.postgresql.org/wiki/Submitting_a_Patch
> <https://wiki.postgresql.org/wiki/Submitting_a_Patch>
> --
> Michael
>
>
>
>
> --
> Jelen
> Starší čeledín datovýho chlíva
>
>
>
>
> --
> Jelen
> Starší čeledín datovýho chlíva
>
>
>
>
> --
> Jelen
> Starší čeledín datovýho chlíva
>
>
>
>
> --
> Jelen
> Starší čeledín datovýho chlíva
>
>
>

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