Re: psql format result as markdown tables - Mailing list pgsql-general

From Melvin Davidson
Subject Re: psql format result as markdown tables
Date
Msg-id CANu8Fiz5gf1j6FpF+dcrftZdHz83VAAqLEaAbX0H+o0feckCcQ@mail.gmail.com
Whole thread Raw
In response to psql format result as markdown tables  (Nicolas Paris <niparisco@gmail.com>)
Responses Re: psql format result as markdown tables  (Stephen Frost <sfrost@snowman.net>)
List pgsql-general


On Sat, Jan 13, 2018 at 4:50 AM, Nicolas Paris <niparisco@gmail.com> wrote:
Hello

I wonder if someone knows how to configure psql to output results as
markdown tables.
Then instead of :

SELECT * FROM (values(1,2),(3,4)) as t;
 column1 | column2
---------+---------
       1 |       2
       3 |       4

Get the result as :
SELECT * FROM (values(1,2),(3,4)) as t;
| column1 | column2|
|---------|--------|-
|       1 |       2|
|       3 |       4|

Thanks by advance


A. You have not graced us with PostgreSQL version and O/S
B. Your two examples appear exactly the same.

Found with a google search of .... sql markdown table

--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgres 9.4 using primary key index in almost all queries leading to degraded performance
Next
From: Stephen Frost
Date:
Subject: Re: psql format result as markdown tables