Feature Request: cache data

[killerwzb]

When using PostgreSQL and performing data calculations through pg_duckdb, data needs to be fetched from PostgreSQL each time for computation. Is it possible to provide a feature to cache PostgreSQL data so that it is not necessary to fetch data every time?
This can improve the performance of analysis and reduce the time spent on data fetching.

[JelteF]

You can use CREATE TEMP TABLE my_duck_cache USING duckdb AS SELECT * FROM pg_table. If you want to remove the TEMP from that query because you want to use the cache across different connections to Postgres, then you have to use MotherDuck currently.