DuckDB-PGQ

This is a forked repository of DuckDB to support the DuckPGQ extension. Do not clone this repository directly to use the DuckPGQ extension. To build the extension from source, see the DuckPGQ repository and the documentation page for instructions.

Loading DuckPGQ into DuckDB

For availability please see the DuckPGQ extension availability section.

Since this is a third-party extension, DuckDB must be started in unsigned mode to load it. The extension can be loaded with the following commands:

For CLI:

duckdb -unsigned

set custom_extension_repository = 'http://duckpgq.s3.eu-north-1.amazonaws.com';
force install 'duckpgq'; # ensures any existing DuckPGQ version already installed is overwritten
load 'duckpgq';

For Python:

import duckdb 
conn = duckdb.connect(config = {"allow_unsigned_extensions": "true"})

conn.execute("set custom_extension_repository = 'http://duckpgq.s3.eu-north-1.amazonaws.com';")
conn.execute("force install 'duckpgq';")
conn.execute("load 'duckpgq';")