Re: Importing undelimited files (Flat Files or Fixed-Length records)

From: ptjm(at)news-reader-radius(dot)uniserve(dot)com (Patrick TJ McPhee)
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Importing undelimited files (Flat Files or Fixed-Length records)
Date: 2008-06-22 18:24:22
Message-ID: _YudnUmYKrZLBcPVnZ2dnUVZ_rvinZ2d@posted.uniservecommunications
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In article <485AE3AA(dot)3030700(at)gisnet(dot)com>, Bill Thoen <bthoen(at)gisnet(dot)com> wrote:
% I've got to load some large fixed-legnth ASCII records into PG and I was
% wondering how this is done. The Copy command looks like it works only
% with delimited files, and I would hate to have to convert these files to
% INSERT-type SQL to run them through psql.. Is there a way one can
% specify a table structure with raw field widths and then just pass it a
% flat file?

pg_loader is supposed to handle this.

http://pgfoundry.org/projects/pgloader

--

Patrick TJ McPhee
North York Canada
ptjm(at)interlog(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message ITAGAKI Takahiro 2008-06-23 01:18:36 Re: partitioned table insert triggers
Previous Message Josh Tolley 2008-06-22 15:48:47 Re: postgres generates too much processes per minute