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

I know, but, both new linestyles are created literally by cloning ascii
linestyle and few lines in print_aligned_text. Both works with "aligned"
and "wrapped" format. In rst is wrapped format useful, in my opinion, in
markdown i can`t find how I can get newline in record (maybe it is not
posiible in main markdown types). So it is why i add markdown and rst as
new linestyles. But it is not problem to change it in command to use "\pset
format", but i mean, that this is cleaner.

Je;

jelen=# \pset linestyle rst
Line style is rst.
jelen=# \pset format wrapped
Output format is wrapped.
jelen=# SELECT repeat('Goodnight Irene ', 30);
+-----------------------------------------------------------------------------+
|
repeat |
+=============================================================================+
| Goodnight Irene Goodnight Irene Goodnight Irene Goodnight Irene Goodnight
I.|
|.rene Goodnight Irene Goodnight Irene Goodnight Irene Goodnight Irene
Goodni.|
|.ght Irene Goodnight Irene Goodnight Irene Goodnight Irene Goodnight Irene
G.|
|.oodnight Irene Goodnight Irene Goodnight Irene Goodnight Irene Goodnight
Ir.|
|.ene Goodnight Irene Goodnight Irene Goodnight Irene Goodnight Irene
Goodnig.|
|.ht Irene Goodnight Irene Goodnight Irene Goodnight Irene Goodnight Irene
Go.|
|.odnight Irene Goodnight
Irene |
+-----------------------------------------------------------------------------+

(1 row)

jelen=#

2017-03-01 15:00 GMT+01:00 Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)
com>:

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

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