# Adding Constant Column Values with pgloader

DevFeed: [Adding Constant Column Values with pgloader](<https://devfeed.tech/articles/pgloader-constant-cols-34442.md>)

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

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2011-08-12T09:00:00Z

Content type: tutorial

Language: en

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

Topics: [configuration](<https://devfeed.tech/topics/configuration.md>), [file](<https://devfeed.tech/topics/file.md>), [data](<https://devfeed.tech/topics/data.md>)

Tags: [articles](<https://devfeed.tech/tags/articles.md>), [configuration](<https://devfeed.tech/tags/configuration.md>), [examples](<https://devfeed.tech/tags/examples.md>), [file](<https://devfeed.tech/tags/file.md>), [how-to](<https://devfeed.tech/tags/how-to.md>)

## AI overview

This tutorial explains how to use pgloader to add constant values to a target table column during data loading. It discusses user-defined columns, configuration, and an example setup, while noting that the article focuses on unsupported pgloader 2.x and recommends pgloader 3.x.

## Source excerpt

The previous articles in the pgloader series detailed How To Use PgLoader then How to Setup pgloader, then what to expect from a parallel pgloader setup, and then pgloader reformating. Another need you might encounter when you get to use pgloader is adding constant values into a table's column.