36.2. Querying Postgres Pro Tables #
For analytical queries on your existing Postgres Pro tables, use standard SQL. No special syntax is needed. pgpro_axe automatically accelerates these queries when you set the duckdb.force_execution configuration parameter to true.
Example 36.2.
SET duckdb.force_execution = true; -- Standard SELECT on a Postgres Pro table SELECT category, AVG(price) as avg_price, COUNT(*) as item_count FROM products -- This is a regular Postgres Pro table GROUP BY category ORDER BY avg_price DESC;
SET duckdb.force_execution = true; -- Standard SELECT on a Postgres Pro table SELECT category, AVG(price) as avg_price, COUNT(*) as item_count FROM products -- This is a regular Postgres Pro table GROUP BY category ORDER BY avg_price DESC;