Postgresql REPL save query result into variable

Question

In mysql REPL it's possible to do something like this:

set @x = 1;
set @d = (select now());
select @x, @d;
+------+---------------------+
| @x   | @d                  |
+------+---------------------+
|    1 | 2018-11-22 16:38:11 |
+------+---------------------+

Now I try to do same in postgresql REPL. I've found this:

set var.x = 1;
select current_setting('var.x');

And it works, but I can't find the way how to store query result into variable. I've tried this:

set var.d = (select now());
ERROR:  syntax error at or near "("
LINE 1: set var.d = (select now());
                    ^

select now() into var.d;
ERROR:  schema "var" does not exist

select now() into d;
-- creates new table, which is wrong

d := select now();
ERROR:  syntax error at or near "d"
LINE 1: d := select now();

Could you please help find the solution? I'm ussing psql (PostgreSQL) 10.5.

cn0047 · Accepted Answer · 2018-11-22 17:52:04Z

1

Im not sure if this is what you are looking for, but there is this a way. You can generate a result and store it to a variable like so:

\set x 1
select now() \gset
select :x, :'now';

Result will be:

 ?column? |           ?column?
----------+-------------------------------
        1 | 2018-11-22 19:50:38.391587+02
(1 row)

edited Nov 22, 2018 at 17:52

cn0047

17.2k7 gold badges61 silver badges75 bronze badges

answered Nov 22, 2018 at 17:35

Tony

6542 gold badges6 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

Postgresql REPL save query result into variable

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