Re: Fixed field text import - Mailing list pgsql-general

From Harald Fuchs
Subject Re: Fixed field text import
Date
Msg-id puwuahxtk9.fsf@srv.protecting.net
Whole thread Raw
In response to Re: Automatic auditing suggestion  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
In article <20031031135626.H35878-100000@storm.niwa.co.nz>,
Brent Wood <b.wood@niwa.co.nz> writes:

> Is there an easy way (similar to COPY) to import fixed width text files
> directly into Postgres tables?

> COPY is fine for files with delimited fields, but I have fixed format text
> files to import into tables.

How about inserting the necessary delimiters with sed and piping sed's
output into "COPY FROM stdin"?

pgsql-general by date:

Previous
From: Andrew Ayers
Date:
Subject: Re: ALTER Table (another)
Next
From: Alexandr S
Date:
Subject: question