From sistemascmp@redynet4.com.ar Fri Sep 29 13:48:05 2006 Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 111D49FB31A for ; Fri, 29 Sep 2006 10:48:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 45646-01 for ; Fri, 29 Sep 2006 10:48:02 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from joyin.redynet.com.ar (smtp.redynet.com.ar [200.69.11.15]) by postgresql.org (Postfix) with SMTP id 1E1009FA5B4 for ; Fri, 29 Sep 2006 10:48:00 -0300 (ADT) Received: (qmail 3840 invoked by uid 82); 29 Sep 2006 14:07:37 -0000 Received: from unknown (HELO pcsistemas) (200.69.8.40) by smtp.redynet.com.ar with SMTP; 29 Sep 2006 14:07:37 -0000 Message-ID: <002e01c6e3cc$fa0e1be0$0d01a8c0@pcsistemas> From: "Sistemas C.M.P." To: Subject: Copy to another server Date: Fri, 29 Sep 2006 10:41:33 -0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_002B_01C6E3B3.D4A0D8C0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1807 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.068 tagged_above=0 required=5 tests=AWL, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200609/364 X-Sequence-Number: 23278 This is a multi-part message in MIME format. ------=_NextPart_000_002B_01C6E3B3.D4A0D8C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I need to select a group of records in one table, and then copy this = group to similar table in another database and another server. How can I do this? ------=_NextPart_000_002B_01C6E3B3.D4A0D8C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I need to select a group of records in = one table,=20 and then copy this group to similar table in another database and = another=20 server.
How can I do = this? 
------=_NextPart_000_002B_01C6E3B3.D4A0D8C0-- From bruno@wolff.to Sat Sep 30 02:46:41 2006 Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id CBB519FB2A4 for ; Fri, 29 Sep 2006 23:46:41 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 38105-04 for ; Sat, 30 Sep 2006 02:46:33 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from wolff.to (wolff.to [66.93.197.194]) by postgresql.org (Postfix) with SMTP id 1D6F79FB224 for ; Fri, 29 Sep 2006 23:46:32 -0300 (ADT) Received: (qmail 9008 invoked by uid 500); 30 Sep 2006 02:56:41 -0000 Date: Fri, 29 Sep 2006 21:56:41 -0500 From: Bruno Wolff III To: "Sistemas C.M.P." Cc: pgsql-admin@postgresql.org Subject: Re: Copy to another server Message-ID: <20060930025641.GA8973@wolff.to> Mail-Followup-To: Bruno Wolff III , "Sistemas C.M.P." , pgsql-admin@postgresql.org References: <002e01c6e3cc$fa0e1be0$0d01a8c0@pcsistemas> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <002e01c6e3cc$fa0e1be0$0d01a8c0@pcsistemas> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200609/389 X-Sequence-Number: 23303 On Fri, Sep 29, 2006 at 10:41:33 -0300, "Sistemas C.M.P." wrote: > I need to select a group of records in one table, and then copy this group to similar table in another database and another server. > How can I do this? Long at using the dblink contrib module. If that isn't available to you, then you can select the data into a temp table and use copy to produce csv output (in 8.2 you will be able to skip the temp table step) and then import the csv file into the other database.