pg_quack

pg_quack is PostgreSQL with Embedded DuckDB :duck:

Installation

With pgxman

1. Install pgxman
2. pgxman install pg_quack

From source

1. make install
2. (Optional) Create quack directory and set permissions so PostgreSQL process can write to it. Directory can be changed with quack.data_dir configuration parameter. By default, the directory is quack in your Postgres data directory.

postgres=# show quack.data_dir ;
           quack.data_dir
------------------------------------
 /opt/database/postgres/data/quack/
(1 row)

Usage

CREATE TABLE quack_test (...) USING quack;

Limitations

• PG 14 and PG 15 only (PG 16 is not yet supported)
• Only COPY, INSERT, and SELECT are supported.
• Only single connection can execute INSERT and SELECT against quack table
• Limited support for only basic data types
• You cannot query between quack tables and other storage methods (including Postgres heap tables).