Answers for "store postgresql result in shell variable"

1

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
1

postgres output 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 March-31-2020

Code answers related to "store postgresql result in shell variable"

Code answers related to "Shell/Bash"

Browse Popular Code Answers by Language