# Reformatting Input Columns with pgloader

DevFeed: [Reformatting Input Columns with pgloader](<https://devfeed.tech/articles/pgloader-reformating-34444.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2011/08/pgloader-reformating/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2011-08-05T09:30:00Z

Content type: tutorial

Language: en

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

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [data type](<https://devfeed.tech/topics/data-type.md>), [Python](<https://devfeed.tech/topics/python.md>), [parallel](<https://devfeed.tech/topics/parallel.md>), [Scripting](<https://devfeed.tech/topics/scripting.md>)

Tags: [article](<https://devfeed.tech/tags/article.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [parallel](<https://devfeed.tech/tags/parallel.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [python](<https://devfeed.tech/tags/python.md>), [scripting](<https://devfeed.tech/tags/scripting.md>), [transformation](<https://devfeed.tech/tags/transformation.md>)

## AI overview

This tutorial explains how pgloader reformats input columns before PostgreSQL receives them. It describes configuring reformat modules and functions, and implementing the transformation in Python, including an example that converts certain MySQL timestamp representations into a PostgreSQL-readable form.

## Source excerpt

Back to our series about pgloader. The previous articles detailed How To Use PgLoader then How to Setup pgloader, then what to expect from a parallel pgloader setup. This article will detail how to reformat input columns so that what PostgreSQL sees is not what's in the data file, but the result of a transformation from this data into something acceptable as an input for the target data type.