Online Documentation for SQL Manager for PostgreSQL

Execute queries with parameters

If you want to use queries with parameters then you should check Allow using parameters in query text option in the Environment Options | Tools.

This feature allows you to specify different values within a query in a popup dialog just before the query execution. Use the colon (':') character before an identifier (e.g. :P1) to specify a parameter within the query.