Re: Copying data from a table to another database

You can do this with dblink
http://www.postgresql.org/docs/8.3/interactive/contrib-dblink.html
pretty easily.


Jon

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Pedro Doria Meunier
> Sent: Sunday, May 25, 2008 6:25 AM
> To: Postgresql Mailing List
> Subject: [GENERAL] Copying data from a table to another database
> Importance: High
>
> Hi all,
>
> This is perhaps a very 'newbie' question but for the life of me, I
can't
> see a way to do it without resorting to programming... (blush)
>
> The thing is:
> I have a table that acts as a historic for some devices activity.
> Now I've migrated the entire 'shebang' to another server and need to
> update the history table on the new server with data from the old
server
> for every different record.
> As the table on the new server grows exponentially (already nearing 1M
> records) I need to do this asap unless I want the entire thing to take
> forever... (sweat)
>
> Could someone please lend me a hand here?
>
> Already thankful for any insight,
>
> --
> Pedro Doria Meunier <pdoria@netmadeira.com>