Quick Links

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

From:	Bill Thoen <bthoen(at)gisnet(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	Importing undelimited files (Flat Files or Fixed-Length records)
Date:	2008-06-19 22:54:34
Message-ID:	485AE3AA.3030700@gisnet.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	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?

Responses

Re: Importing undelimited files (Flat Files or Fixed-Length records) at 2008-06-19 23:07:18 from Douglas McNaught
Re: Importing undelimited files (Flat Files or Fixed-Length records) at 2008-06-19 23:58:04 from Gregory Williamson
Re: Importing undelimited files (Flat Files or Fixed-Length records) at 2008-06-20 00:35:03 from Adrian Klaver
Re: Importing undelimited files (Flat Files or Fixed-Length records) at 2008-06-22 18:24:22 from Patrick TJ McPhee

Browse pgsql-general by date

	From	Date	Subject
Next Message	David Spadea	2008-06-19 23:07:10	Re: renumber table
Previous Message	Joshua D. Drake	2008-06-19 22:15:06	Re: Losing data