Hi,
I was wondering if it was possible to use psql, or another client, to perform SQL queries across multiple databases.
Wecurrently write no end of perl scripts to perform our operations across DBs - it'd be nice to have a method to do it
moresimply.
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