How to create a variable in a bash script that contains the data from a postgres database

Question

I'm looking to create a script than can find a specific date/time based on a field in a database Currently i do it manually...

# psql gttvdb -U postgres
gttvdb=# select patch_date from version_history where version ='1.1.1';

What i need is to be able to reference that date as a variable in a bash script

#! /bin/sh
patchdate=$("select patch_date from version_history where version ='1.1.1';")
echo "last update was " $patchdate

Szymon Guz · Accepted Answer · 2012-08-10 18:35:54Z

up vote 3 down vote accepted

Try this:

patchdate=` psql -t -q -c "select patch_date from version_history where version ='1.1.1'"`

answered Aug 10 '12 at 18:35

Szymon Guz
5,33273257

Thanks, that lead me to the right place... – user1591029 Aug 10 '12 at 19:49

read dtin patchdate=

psql gttvdb -U postgres -t -q -c "select patch_date from version_history where version = '$dtin' ORDER BY ID DESC limit 1;"

– user1591029 Aug 10 '12 at 19:56

yep, exactly :) – Szymon Guz Aug 10 '12 at 20:19

add a comment |

1 Answer 1