Using Parameters for SQL Queries

Last modified: June 26, 2023

You can benefit from using parameters in the following situations:

• When you execute a query multiple times with different input values

• When you debug a query from your application code.

Adding Parameters to a Query Text

Parameters are declared using = symbol followed by the parameter value.

For example:

SELECT * FROM <table_name> 
WHERE <column_name> = $1;

Modifying Parameter Values and Types

When you run a query that contains parameters with empty values, you will automatically be prompted to initialize them.

To set parameter values and types, select Edit Parameters option from the SQL menu or press F8. In the Edit Parameters dialog box, set parameters’ type, value, and other properties.

Note

When you execute a query with preset parameter values, you will not be automatically prompted to edit them. To edit parameters, press F8 or select Edit Parameters option from the SQL menu.