X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id C464BD1C4D5 for ; Fri, 1 Aug 2003 10:50:55 +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 34385-01 for ; Fri, 1 Aug 2003 07:49:47 -0300 (ADT) Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52]) by svr1.postgresql.org (Postfix) with SMTP id 7A99AD1C4BF for ; Fri, 1 Aug 2003 07:50:49 -0300 (ADT) Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ; Fri Aug 01 12:50:50 2003 +0200 Received: œby rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id MAA01411; Fri, 1 Aug 2003 12:50:49 +0200 (METDST) Message-ID: <3F2A4609.5E31FCFF@rodos.fzk.de> Date: Fri, 01 Aug 2003 12:50:49 +0200 From: Christoph Haller X-Mailer: Mozilla 4.77 [en] (X11; U; HP-UX B.10.20 9000/780) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org, xhua@cse.ucsc.edu Subject: Re: load database from ascii files Content-Type: text/plain; charset=iso-8859-2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Amavis-Alert: BAD HEADER Non-encoded 8-bit data (char 9C hex) in message header 'Received' Received: \234by rodos.fzk.de... ^ X-Archive-Number: 200308/2 X-Sequence-Number: 4356 > 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? The order of things is first create, then load. There are excellent tools to populate pg databases, but your request is vague, so I just have to tell you RTFM. Regards, Christoph PS The proper list is rather [SQL].