# Import fixed width data with pgloader

DevFeed: [Import fixed width data with pgloader](<https://devfeed.tech/articles/import-fixed-width-data-with-pgloader-34529.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2013/11/import-fixed-width-data-with-pgloader/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2013-11-18T11:48:00Z

Content type: tutorial

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [import](<https://devfeed.tech/topics/import.md>), [data](<https://devfeed.tech/topics/data.md>), [Common Lisp](<https://devfeed.tech/topics/common-lisp.md>)

Tags: [code](<https://devfeed.tech/tags/code.md>), [file](<https://devfeed.tech/tags/file.md>), [import](<https://devfeed.tech/tags/import.md>), [lisp](<https://devfeed.tech/tags/lisp.md>)

## AI overview

This article revisits importing fixed-width data with pgloader, correcting earlier timing methodology and comparing results with a newer version. It reports loading times ranging from 366 to 700 milliseconds and describes a command that downloads and unpacks a ZIP source before loading and trimming the data.

## Source excerpt

A long time ago we talked about how to Import fixed width data with pgloader, following up on other stories still online at Postgres OnLine Journal and on David Fetter's blog. Back then, I showed that using pgloader made it easier to import the data, but also showed quite poor performances characteristics due to using the debug mode in the timings. Let's update that article with current pgloader wonders!