Thread: Load fixed length records.

Load fixed length records.

From
"Martin Schweitzer"
Date:
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