Обсуждение: Can I do this?

Wei,

> I want to select some data out of database A, and insert them into database
B. Is it possible to do in one SQL query?
>

No.   Use a Perl script.

--
-Josh BerkusAglio Database SolutionsSan Francisco

See /contrib/dblink, or use an application that attaches to both
databases, or use COPY somehow.

---------------------------------------------------------------------------

Wei Weng wrote:
> I want to select some data out of database A, and insert them into database B. Is it possible to do in one SQL
query?
> 
> Thanks
> 
> Wei

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073