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 | CAAYBy8ZN9GXTxQmynSwsxbqdF9iCO6RaLiAoHx30nA+QPLauPw@mail.gmail.com Whole thread Raw |
| In response to | Re: [HACKERS] Other formats in pset like markdown, rst, mediawiki (Pavel Stehule <pavel.stehule@gmail.com>) |
| Responses |
Re: [HACKERS] Other formats in pset like markdown, rst, mediawiki
|
| List | pgsql-hackers |
It is question if it is really new format, because formating is the same as aligned/wrapped format, changed is only style of lines.
2017-03-05 12:36 GMT+01:00 Pavel Stehule <pavel.stehule@gmail.com>:
2017-03-05 11:40 GMT+01:00 Jan Michálek <godzilalalala@gmail.com>: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.Using a special linestyle for new format is possible probably. But new format should be switched with \pset format command.Not sure if wrapped or aligned behave is correct for markdown - it is task for markdown processing, not for psql.RegardsPavelJe;
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.eisentraut@2ndquadrant.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@gmail.com
> <mailto:godzilalalala@gmail.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@gmail.com
> <mailto:godzilalalala@gmail.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@gmail.com
> <mailto:godzilalalala@gmail.com>>: > <michael.paquier@gmail.com <mailto:michael.paquier@gmail.>
> 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@laptak patch_postgre_rst]$
> [jelen@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 Paquiercom>>:
>
> On Fri, Feb 24, 2017 at 3:09 AM, Jan Michálek
> <godzilalalala@gmail.com--> <mailto:godzilalalala@gmail.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
--JelenStarší čeledín datovýho chlíva
--
Jelen
Starší čeledín datovýho chlívapgsql-hackers by date: