Rich
obviously
s/MySQL/PostgreSQL/g
would do the trick.
There is also, of course,
luarocks install luasql-postgres
and then the SQLite3 example from
https://tex.stackexchange.com/questions/48193/reading-data-from-a-relational-database-into-a-latex-table
which is trivially adapted to generate supertabular.
All of the above I still find easier than something like
psql -P format=latex | supertabfiler > psqltable.tex
(which needs to be done only once and can the be included into the LyX
file.
I prefer the R solution, because I am used to it for the diagram
generation.
el
On 2018-11-02 16:43 , Rich Shepard wrote:
> On Fri, 2 Nov 2018, Dr Eberhard Lisse wrote:
>
>> Somehow my reply from the iPad Newsreader got lost.
>
> It's a long way from southwestern Africa. :-)
>
>> Why not include R Chunks generating tables and/or graphics at PDF
>> generation in the LyX file using the knitr module?
>
> Two reasons:
>
> 1) It's a static table; once entered it's not changed.
>
> 2) The table data was exported from the postgres database table.
>
> Thanks, Eberhard,
>
> Rich
>
