Table of Contents
You can configure pgpro_axe parameters in the
postgresql.conf file.
duckdb.force_execution #Forces queries to use DuckDB execution. This is necessary when accessing only Postgres Pro tables in a query. As soon as you use a DuckDB-only feature, DuckDB execution is used automatically.
DuckDB-only features
include reading from DuckDB
tables, using DuckDB functions (e.g.,
read_parquet) or COPY to
a remote storage (e.g., s3://).
Default value: false.
Access: All users.
duckdb.default_collation #Specifies the default collation to use for DuckDB string operations and sorting. This parameter allows configuring locale-specific string comparison behavior.
Example 23.1.
"en_us"
"de_de"
"C"
Default value: "" — uses
DuckDB default.
Access: Superuser-only.