Query Parameters in PGAdmin

Question

Most GUI SQL Consoles allow the use of parameters/placeholders as follows

SELECT * FROM USERS WHERE USER_NAME = :USER_NAME;

You are usually (e.g. Toad, IntelliJ, etc.) presented with a dialog where you have to enter a value for each parameter. However, in PGAdmin I get a syntax error. Is this not supported in PGAdmin or do they use a different syntax?

Samantha Catania · Accepted Answer · 2018-07-16 12:05:17Z

1

PGAdmin does not seem to support bind variables; but I found a work around on another : question

WITH VARS AS (SELECT 'Name.Surname'::VARCHAR AS USER_NAME)
SELECT * FROM USERS, VARS WHERE USER_NAME = VARS.USER_NAME;

answered Jul 16, 2018 at 12:05

Samantha Catania

5,3266 gold badges43 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Query Parameters in PGAdmin

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related