appmixer.postgres.db.Query
1.0.0
Public
| Field | Type | Description |
|---|---|---|
| Query | text | Enter an SQL query. |
| Output Type | select | Choose whether you want to receive the result set as one complete list, or one row at a time or stream the rows to a file. For large datasets, streaming the rows to a file is the most efficient method (in Async Mode the result is streamed to a CSV file and only the File ID is delivered). |
| Async Mode | toggle | Enable for long-running queries that may exceed the standard timeout (~23 minutes). Uses the PostgreSQL dblink extension to execute the query asynchronously in a background read-only session. Requires CREATE EXTENSION IF NOT EXISTS dblink on the target database. Only a single read-only SELECT (or WITH ... SELECT) statement is supported. For large result sets choose the Stream to file output type — the result is streamed to a CSV file. |
Dynamic variables loaded from /component/appmixer/postgres/db/Query?outPort=out&ignoreAuth=true
| Field | Type | Description |
|---|---|---|
| SQL Query | - | |
| Message | - |