Re: printing table in asciidoc with psql

On 31 March 2015 at 16:35, Bruce Momjian <bruce(at)momjian(dot)us> wrote:

> On Wed, Mar 25, 2015 at 09:12:41AM -0400, Bruce Momjian wrote:
> > On Wed, Mar 25, 2015 at 09:37:08PM +0900, Michael Paquier wrote:
> > > On Wed, Mar 25, 2015 at 4:59 PM, Bruce Momjian <bruce(at)momjian(dot)us>
> wrote:
> > > > On Wed, Mar 25, 2015 at 02:18:58PM +0900, Michael Paquier wrote:
> > > >> > [options="header",cols="<l,<l",frame="none"]
> > > >> > |====
> > > >> > |5 2.2+^.^ |4 2.2+^.^
> > > >> > |2 2.2+^.^ |3 2.2+^.^
> > > >> > |====
> > > >>
> > > >> Hm. This is still incorrect. You should remove options="header" here
> > > >> or the first tuple is treated as a header in the case
> > > >> non-expanded/tuple-only. Your patch removes correctly the header for
> > > >> the expanded/tuple-only case though.
> > > >> Regards,
> > > >
> > > > OK, fixed. Thanks for the testing. Patch attached. New output:
> > >
> > > This time things look good from my side. I have played with this patch
> > > some time, testing some crazy scenarios and I have not found problems.
> > > That's cool stuff, thanks!
> >
> > Wow, thanks. I never would have gotten here without your help.
>
> Slightly updated patch attached and applied. I moved asciidoc after
> HTML in the list, rather than at the end. Thanks for everyone's hard
> work on this.

I think I done gone broke it:

CREATE TABLE "| 3^.||moo|hello," (stuff int, "|&.^hje||" text);

INSERT INTO "| 3^.||moo|hello," VALUES (2,'hello');

Output:

[options="header",cols=">l,<l",frame="none"]
|====
^l|stuff ^l|\|&.^hje\|\|
|2 |hello
|====

....
(1 row)
....

This results in:

<table class="tableblock frame-none grid-all spread">
<colgroup>
<col style="width: 50%;">
<col style="width: 50%;">
</colgroup>
<thead>
<tr>
<th class="tableblock halign-center valign-top">stuff</th>
<th class="tableblock halign-center valign-top">|&amp;.^hje||2</th>
</tr>
</thead>
</table>

Using asciidoctor 1.5.2.

--
Thom