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@xxxxxxxxxxxxxx [mailto:pgsql-general- > owner@xxxxxxxxxxxxxx] 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@xxxxxxxxxxxxxx>
