How to declare a variable in PostgreSQL?

Question

I have several queries in a query window in pgAdmin, many using the same value(s). Is there a way to declare a variable, myVar to use in query statements?

SELECT * FROM table WHERE user = myVar;

INSERT INTO table(user) VALUES (myVar);

FancyXun · Accepted Answer · 2017-04-21 01:17:24Z

2

A simple example:

DO $$
DECLARE  
   myVar VARCHAR := myValue;   
BEGIN  
   INSERT INTO table(user) VALUES (myVar);
END $$;

answered Apr 21, 2017 at 1:17

FancyXun

1,2981 gold badge10 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

How to declare a variable in PostgreSQL?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related