On 10/12/26 11:12 PM, Färber, Franz-Josef (StMUK) wrote:
Thanks for the suggestion.
But what exactly is the suggestion?
That you also read the links included, where it shows that DuckDb is
available from a multitude of languages and can connect to a Postgres
database to share information. Think it of as in-memory database to do
the scratch work that you then pass into Postgres. It is definitely a
round about way of tackling the problem.
At least I understand DuckDB can directly read without having to craete a temp
table:
* SELECT * FROM 'test.csv.gz';
* SELECT * FROM read_csv('test.csv', header = false);
... which is what Postgres is missing.
Regards,
Franz-Josef Färber
--
Adrian Klaver
[email protected]
