[spapas82]

If you have some data in postgresql and want to query it with duckdb (really fast) you can try extracting the data to a parquet file; this file can then be queried from duckdb with incredible speed. I've written a small program in python that reads from postgresql and exports to parquet for anybody that wanna try it https://github.com/spapas/pg-parquet-py#why

[chrisjc]

There's also the option to use the DuckDB PostgreSQL scanner

https://duckdb.org/docs/archive/0.9.1/extensions/postgres_sc...