X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 71A0132A1A6 for ; Mon, 18 Oct 2004 21:16:03 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 13579-04 for ; Mon, 18 Oct 2004 20:15:55 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 756DA329F7E for ; Mon, 18 Oct 2004 21:15:55 +0100 (BST) Received: (qmail 21208 invoked by uid 500); 18 Oct 2004 20:26:32 -0000 Date: Mon, 18 Oct 2004 15:26:32 -0500 From: Bruno Wolff III To: Chuming Chen Cc: pgsql-admin list Subject: Re: insert a file into remote database Message-ID: <20041018202632.GA21166@wolff.to> Mail-Followup-To: Chuming Chen , pgsql-admin list References: <41741B8C.7040600@musc.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <41741B8C.7040600@musc.edu> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/220 X-Sequence-Number: 15213 On Mon, Oct 18, 2004 at 15:37:48 -0400, Chuming Chen wrote: > Hi, all, > > Is there anyway to insert a local text file into a table in a remote > database server? Perhaps psql's \copy command will do what you want.