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.