Importing undelimited files (Flat Files or Fixed-Length records) - Mailing list pgsql-general

From Bill Thoen
Subject Importing undelimited files (Flat Files or Fixed-Length records)
Date
Msg-id 485AE3AA.3030700@gisnet.com
Whole thread Raw
Responses Re: Importing undelimited files (Flat Files or Fixed-Length records)  ("Douglas McNaught" <doug@mcnaught.org>)
Re: Importing undelimited files (Flat Files or Fixed-Length records)  (Adrian Klaver <aklaver@comcast.net>)
List pgsql-general
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?


pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Losing data
Next
From: "David Spadea"
Date:
Subject: Re: renumber table