SQL Queries across multiple databases

Hi,

I was wondering if it was possible to use psql, or another client, to perform SQL queries across multiple databases. We currently write no end of perl scripts to perform our operations across DBs - it'd be nice to have a method to do it more simply.

I suppose I could do something like:

echo "select into temp table blah..." | psql db; pg_dump -t blah db | psql other_db

Is there another, more direct way of doing this, that anyone knows of?

Thanks in advance,
Rajit