Parameterized Query

No PostgreSQL specific customizations were made for this feature.

Parameterized queries contain parameter markers as a placeholders for data that changes during each execution. When using the Connectivity wizard to create a DSN for a database instance, create a new connection and enable the parameterized query option as shown below.

The following example shows a parameterized query using a text prompt from a freeform SQL report:

INSERT INTO PARAMETERIZED_TEST 
    VALUES ( 1000, -1599838343134390588, '2019-05-28', ?, ?, ? );