Postgres Pro
Downloads
Home   >   mailing lists

Load fixed length records. - Mailing list pgsql-general

From Martin Schweitzer
Subject Load fixed length records.
Date
Msg-id 015501c09eef$9f921fe0$020a0a0a@martin
Whole thread Raw
List pgsql-general
Tree view
Hi
 
I am receiving records as fixed length ascii.  I would like to load them into PostgreSQL tables.  I could write an ecpg program to parse the records and do an insert - or I could write an awk script to split the records and insert delimiters, then use COPY (which is what I did), but I was wondering if there were some generalised tools out there for the task, or if someone had a better option?
 
Thanks.
 
Martin
 

pgsql-general by date:

Previous
From: Ian Harding
Date:
Subject: Re: Problem with PL/pgSQL
Next
From: "Steve O'Hagan"
Date:
Subject: Migrate from MS SQL 6.5 to postgres??