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