/Shell/Bash/Postgres output to bash variable

Postgres output to bash variable

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'"`

1

Source: stackoverflow.com

Similar codes

0 vote153 views1 answer
How to kill process by command bu username
Shell/Bash
0 vote131 views1 answer
How to disable suspend in ubuntu 20.04
Shell/Bash
0 vote145 views2 answers
Surge installation
Shell/Bash
7 votes137 views1 answer
Speedtest python oneliner
Shell/Bash
14 votes164 views3 answers
Compress folder ubuntu
Shell/Bash
0 vote135 views1 answer
Powershell delete all files wit hextension
Shell/Bash
0 vote141 views1 answer
How to install pycaw
Shell/Bash
0 vote179 views1 answer
Whats up with docker compose and orphan containers
Shell/Bash
0 vote167 views1 answer
Bluetooth headphone not working linux mint
Shell/Bash
0 vote109 views1 answer
Plesk show mailqueue
Shell/Bash

Share