Answers for "declare variable in psql terminal"

psql client write to bash variable

vartest=`psql -X -A -d $dbname -U $username -h localhost -p 5432 -t -c "SELECT gid FROM testtable WHERE aid='1'"`

Posted by: Guest on January-08-2021

postgres declare variable

WITH myconstants (var1, var2) as (
   values (5, 'foo')
)
SELECT *
FROM somewhere, myconstants
WHERE something = var1
   OR something_else = var2;

Posted by: Guest on April-06-2020

Code answers related to "declare variable in psql terminal"