On Sun, Sep 20, 2009 at 3:49 PM, Alex Gadea <alex(dot)gadea(at)apptik(dot)com> 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