Re: import fixed width files into PostgreSQL - Mailing list pgsql-general

From Doug McNaught
Subject Re: import fixed width files into PostgreSQL
Date
Msg-id m3ader9483.fsf@varsoon.wireboard.com
Whole thread Raw
In response to import fixed width files into PostgreSQL  ("Johnson, Shaunn" <SJohnson6@bcbsm.com>)
List pgsql-general
"Johnson, Shaunn" <SJohnson6@bcbsm.com> writes:

> Howdy:
>
> Running PostgreSQL 7.2.1 on RedHat Linux 7.2.
>
> Is it possible to import, or otherwise '\copy', files into Pg tables
> that are in a fixed width (no spaces) format?  If so, am I just
> using copy or is there a method (example) for this somewhere?

COPY requires delimiters; you'll have to massage it into delimited
form (or into INSERT statements) using a Perl script or whatever.

-Doug

pgsql-general by date:

Previous
From: "Corey W. Gibbs"
Date:
Subject: Re: Are we losing momentum? Answer: Heck No!
Next
From: "Jay O'Connor"
Date:
Subject: Re: Appending to an array