On Sun, Sep 20, 2009 at 04:49:03PM -0500, Alex Gadea 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?
>
> Thanks in advance.
>
> Alex
>
>
I tend to use a lot of shell scripts in my production code, i would do
something like this:
#!/bin/sh
dbname=
user=
password=
tables="t1 t2"
for i in $tables;
do
psql -c "\copy (select count(*) from $i) to pstdout csv" \
"dbname=$dbname user=$user password=$password"
done
#END#######################
that would print two lines...
1234134
4565
that are the count(*) of each table.
Use your imagination.
Saludos.
--
DISCLAIMER: http://goldmark.org/jeff/stupid-disclaimers/
This message will self-destruct in 3 seconds.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
