Foreign data wrapper duckdb server

[nasoblu5]

I'm trying to create a foreign duckdb server from Postgresql17 to a duckdb database I created on fs but I'm receiving these errors, can you give me suggestions how to do it?

CREATE SERVER nmv_duckdb_server
FOREIGN DATA WRAPPER duckdb
OPTIONS (type 'file', database_path '/var/lib/postgresql/duck/nmv.db');
ERROR: Missing required option: 'type'

CREATE SERVER nmv_duckdb_server TYPE 'ANY'
FOREIGN DATA WRAPPER duckdb
OPTIONS (database '/var/lib/postgresql/duck/nmv.db');
ERROR: syntax error at or near "ANY"

LINE 1: BEGIN; CREATE SECRET pgduckdb_secret_validation (TYPE ANY, database '/var/lib/postgresql/duck/nmv.db')

[JelteF]

Sadly you cannot read from local duckdb files with pg_duckdb currently.

[JelteF]

See also this issue: #733