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 6258432A8A7 for ; Mon, 18 Oct 2004 20:38:18 +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 97243-07 for ; Mon, 18 Oct 2004 19:38:08 +0000 (GMT) Received: from mopsy2.ccit.musc.edu (mopsy2.musc.edu [128.23.34.56]) by svr1.postgresql.org (Postfix) with ESMTP id 7F53532A892 for ; Mon, 18 Oct 2004 20:38:08 +0100 (BST) Received: from revere3.musc.edu (revere3.musc.edu [128.23.203.9]) by mopsy2.ccit.musc.edu (8.12.10/8.12.10) with ESMTP id i9IJc1A6006138 for ; Mon, 18 Oct 2004 15:38:01 -0400 Received: from cottontail.musc.edu (cottontail.musc.edu [128.23.203.163]) by revere3.musc.edu (8.12.9/8.12.9) with ESMTP id i9IJc0bp026053 for ; Mon, 18 Oct 2004 15:38:00 -0400 (EDT) Received: from [128.23.116.83] (bioinfo-admin.muh.musc.edu [128.23.116.83]) (authenticated bits=0) by cottontail.musc.edu (8.12.10/8.12.10) with ESMTP id i9IJbxJE001779 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NOT) for ; Mon, 18 Oct 2004 15:38:00 -0400 Message-ID: <41741B8C.7040600@musc.edu> Date: Mon, 18 Oct 2004 15:37:48 -0400 From: Chuming Chen Reply-To: chen@musc.edu Organization: Department of Biostatistics, Bioinformatics and Epidemiology, Medical University of South Carolina User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin list Subject: insert a file into remote database Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-MUSC-MailScanner-Information: Please contact postmstr@musc.edu for more information X-MUSC-MailScanner: Found to be clean X-MUSC-MailScanner-SpamCheck: not spam (whitelisted), SpamAssassin (score=0, required 4) X-MailScanner-From: chen@musc.edu 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/218 X-Sequence-Number: 15211 Hi, all, Is there anyway to insert a local text file into a table in a remote database server? Thanks, -- Chuming Chen System Administrator & Programmer Department of Biostatistics, Bioinformatics and Epidemiology Medical University of South Carolina 135 Cannon Street, Suite 303 Charleston SC 29425 Tel: 843-792-1555 (O) Fax: 843-876-1126