Postgres Pro
Downloads
Home   >   mailing lists

Thread: Can I do this?

Can I do this?

From
"Wei Weng"
Date:
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
 

Re: Can I do this?

From
Josh Berkus
Date:
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

Re: Can I do this?

From
Bruce Momjian
Date:
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