15.2. Loading a DuckDB Extension into the Session (duckdb.load_extension) #
Unlike duckdb.install_extension, this stored procedure loads a DuckDB extension into the current session only and does not configure the extension to be loaded automatically in future sessions.
Required privileges: All roles.
Execute the following command on the Postgres Pro AXE server:
SELECT duckdb.load_extension(extension_name) ON CONFLICT DO NOTHING;
Where extension_name is the name of the DuckDB extension that must be loaded into the session.
Postgres Pro AXE loads the DuckDB extension into the session.
Example 15.2. Executing the duckdb.load_extension Stored Procedure
SELECT duckdb.load_extension('iceberg') ON CONFLICT DO NOTHING;