Re: Fixed column format data

From: Shridhar Daithankar <shridhar_daithankar(at)myrealbox(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Fixed column format data
Date: 2003-11-06 15:44:28
Message-ID: 200311062114.28741.shridhar_daithankar@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2003-11-06 15:48:15 Re: [Erserver-general] New eRServer patch/fork release
Previous Message scott.marlowe 2003-11-06 15:41:40 Re: INSERT and UPDATE of ALLBALLS/INFINITY dates and