Re: Fixed field text import - Mailing list pgsql-general

From Doug McNaught
Subject Re: Fixed field text import
Date
Msg-id m365i5md1y.fsf@varsoon.wireboard.com
Whole thread Raw
In response to Fixed field text import  (Brent Wood <b.wood@niwa.co.nz>)
List pgsql-general
Brent Wood <b.wood@niwa.co.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.

There's no built-in method; you'll need to write a script of some sort
to import the data or convert it to delimited format.

-Doug

pgsql-general by date:

Previous
From: "Dave Page"
Date:
Subject: Re: [pgadmin-support] pgAdmin vs SQL Server Enterprise Manager
Next
From: Stephan Szabo
Date:
Subject: Re: Attribute 'rtrim' is repeated