The duckdb_execute function can be used to change the underlying configuration options used by DuckDB.

-- Dollar quoted strings are used to escape single quotes
SELECT duckdb_execute($$SET memory_limit='10GiB'$$);

duckdb_settings returns a table of all available settings.

SELECT * FROM duckdb_settings();

Because a new DuckDB connection is created per Postgres connection, every new Postgres connection uses the default DuckDB configuration. Changes to the DuckDB configuration only apply to the current Postgres connection.

Was this page helpful?

Foreign Table Schema