> Is there a way to connect to one database, extract data,
> (say, some select query) and then export that data
> into another database without having to table the
> data into a file of some sort?
You might want to start learning about the concept of data
types and variables in programming languages (this includes
shells). Also, reading up on how to pipe things from stdout
of one program to stdin of another might help.
If you want to make one database pipe stuff into another
database directly you'd need to learn about the various
approaches summed up under "dblink". One implementation is
found in contrib/. Search the list archive for more on this.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346