Ability to use parameters in query tool (RM #3163)

[dpage]

Issue migrated from Redmine: https://redmine.postgresql.org/issues/3163 Originally created by Big Banana at 2018-03-01 14:54:29 UTC.

Hello everyone,

I often use pgAdmin for work and my company uses plenty of functions and prepared statements. This makes it very tedious to test out such postgres code due to the needing to replace all $ parameters every time something needs to be tested.

Would it be possible to have the option to provide a list of parameters (even just text which gets replaced upon execution)?

In a very simple scenario this would make it extremely easy to work with queries such as:

SELECT * FROM table WHERE column_x = $1::int

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3163#note-1 Originally created by Akshay Joshi at 2018-05-11 10:54:50 UTC.

Possible Design:

• Parameter could be $PG[1] $PG[2] etc..
• When user executes the query ask for the input value for each specified parameter.

Redmine ticket header update:

Name	Old Value	New Value
Sprint changed		Ready

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3163#note-2 Originally created by Aditya Toshniwal at 2021-01-15 11:08:01 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Relationship (duplicated) changed		RM #6146

[ajsmith-savills]

This feature would be very useful, why was is removed from ready?

[adityatoshniwal]

@ajsmith-savills We've discontinued using the label "Ready" and instead started using project - "Ready for Sprint...". So don't worry.

[ajsmith-savills]

Oh excellent, I look forward to seeing this in an upcoming release then!

[KeterSCP]

Any progress on this?