Error for new connections about duckdb_fdw

[alitrack]

CREATE SERVER DuckDB_server
FOREIGN DATA WRAPPER duckdb_fdw;

means you create a duckdb in memory, so it will lost after disconnect.

[imaurer]

Thanks for the insight. Going to switch to the parquet_fdw for my use case. I appreciate the response!

[alitrack]

@imaurer
but you can give a database name, for example,

CREATE SERVER DuckDB_server FOREIGN DATA WRAPPER duckdb_fdw OPTIONS (database '/tmp/test.db');

then when connect next time, it will keep

[imaurer]

Thanks for the clarification!