X-Original-To: pgsql-cygwin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id CD6FED1C50C; Fri, 1 Aug 2003 16:48:52 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 55928-03; Fri, 1 Aug 2003 13:47:44 -0300 (ADT) Received: from localhost.localdomain (unknown [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id 6649DD1C510; Fri, 1 Aug 2003 13:48:50 -0300 (ADT) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by localhost.localdomain (8.12.8/8.12.8) with ESMTP id h71FSxqd021495; Fri, 1 Aug 2003 11:29:00 -0400 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id h71GmlZ02822; Fri, 1 Aug 2003 12:48:47 -0400 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id 34ADNLHL; Fri, 1 Aug 2003 12:48:44 -0400 Subject: Re: [INTERFACES] load database from ascii files From: Robert Treat To: Xinyu Hua Cc: pgsql-interfaces@postgresql.org, pgsql-cygwin@postgresql.org In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 01 Aug 2003 12:48:46 -0400 Message-Id: <1059756526.22273.1635.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/5 X-Sequence-Number: 2645 On Fri, 2003-08-01 at 00:26, Xinyu Hua wrote: > Hi,all > I used the TPC-H database population tool DBgen and generated some ascii > files contain pipe-delimited load data for tables. How may I get these > data loaded to tables and create database in postgresql? > Thanks in advance. > Xinyu > If you have the tables created, I think you only need to do COPY table FROM 'filename' WITH DELIMITER '|' from inside psql and that should work. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL