Re: load database from ascii files

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