Chapter 23. Configuration Parameters
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) orCOPYto 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.