Re: Fixed column format data - Mailing list pgsql-general

From Shridhar Daithankar
Subject Re: Fixed column format data
Date
Msg-id 200311062114.28741.shridhar_daithankar@myrealbox.com
Whole thread Raw
In response to Fixed column format data  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
On Thursday 06 November 2003 21:00, Greg Stark wrote:
> 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?

Well, a simple C program would do the job, isn't it? Of course there could be
some scripting solutions but I don't have anything offhand..

 Shridhar


pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Fixed column format data
Next
From: Andrew Sullivan
Date:
Subject: Re: [Erserver-general] New eRServer patch/fork release