On Sun, Sep 20, 2009 at 3:49 PM, Alex Gadea <alex.gadea@xxxxxxxxxx> wrote: > I am using psql to call an external sql file that executes a simple select > count(*): > > ie: select into ct count(*) from table; > > I can't figure out how to make the ct variable available to the shell script > once the external sql file completes execution. What I am trying to do is > run the count command against a table in two different databases on two > different servers and then compare the variables. > > Any ideas? $x=`psql -At -c "select b from a limit 1;"` $ echo $x test -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
