Re: Fixed field text import

From: Harald Fuchs <nospam(at)sap(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Fixed field text import
Date: 2003-11-03 17:15:02
Message-ID: puwuahxtk9.fsf@srv.protecting.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In article <20031031135626(dot)H35878-100000(at)storm(dot)niwa(dot)co(dot)nz>,
Brent Wood <b(dot)wood(at)niwa(dot)co(dot)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"?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-11-03 17:41:44 Re: Cartesian product bug?
Previous Message Josué Maldonado 2003-11-03 17:05:13 Re: foxpro to postgresql7.1