You can do this with dblink http://www.postgresql.org/docs/8.3/interactive/contrib-dblink.html pretty easily.
Jon > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:pgsql-general- > [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
