Fixed column format data

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Fixed column format data
Date: 2003-11-06 15:30:39
Message-ID: 87vfpxzf8g.fsf@stark.dyndns.tv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Is there any facility to import a text file that's in fixed column format? The
copy command seems to use a delimiter only. I have no delimiter, but have
specified column widths.

Are the only ways to either do many insert queries, or preprocess the file
into a delimited file and then copy?

--
greg

Responses

Browse pgsql-general by date

  From Date Subject
Next Message btober 2003-11-06 15:33:16 Re: Sequences without blank holes
Previous Message Marco Lazzeri 2003-11-06 15:25:18 Re: INSERT and UPDATE of ALLBALLS/INFINITY dates and