pgloader - Import CSV data and Large Object to PostgreSQL

Property Value
Distribution FreeBSD 11
Repository FreeBSD Ports Latest amd64
Package filename pgloader-2.3.1_5.txz
Package name pgloader
Package version 2.3.1
Package release 5
Package architecture amd64
Package type txz
Category databases
License -
Download size 50.06 KB
Installed size 181.06 KB
pgloader imports data from a flat file and inserts it into one or
more PostgreSQL database tables. It uses a flat file per database
table, and you can configure as many Sections as you want, each one
associating a table name and a data file.
Data are parsed and rewritten, then given to PostgreSQL COPY command.
Parsing is necessary for dealing with end of lines and eventual trailing
separator characters, and for column reordering: your flat data file may
not have the same column order as the database table has.
pgloader is also able to load some large objects data into PostgreSQL,
as of now only Informix UNLOAD data files are supported. This command
gives large objects data location information into the main data file.
pgloader parse it add the text or bytea content properly escaped to the
COPY data.
pgloader issues some timing statistics every "commit_every" commits. At
the end of processing each section, a summary of overall operations,
numbers of rows copied and commits, time it took in seconds, errors
logged and database errors is issued.
- DOCS: on


Package Version Architecture Repository
pgloader-2.3.1_5.txz 2.3.1 i386 FreeBSD Ports Latest
pgloader-2.3.1_5.txz 2.3.1 i386 FreeBSD Ports Quarterly
pgloader-2.3.1_5.txz 2.3.1 amd64 FreeBSD Ports Quarterly
pgloader - - -


Name Value
py27-psycopg2 = 2.8.3_1
python27 = 2.7.16_1


Type URL
Binary Package pgloader-2.3.1_5.txz
Source Package databases/pgloader

Install Howto

Install pgloader txz package:

# pkg install pgloader

See Also

Package Description
pgloader3-3.4.1.txz Data loading tool for PostgreSQL,using the COPY command
pglogd-2.3_4.txz Sends web server log entries to a PostgreSQL database
pglogical-2.2.2.txz Logical replication system as a PostgreSQL extension
pgmetrics-1.7.1.txz Collect and display info & stats from a running PostgreSQL server
pgmodeler-0.9.1_4.txz PostgreSQL Database Modeler
pgpdump-0.32.txz PGP packet visualizer
pgpgpg-0.13_4.txz Wrapper for GnuPG to simulate PGP 2.6.x
pgpin-010323_1.txz PGP International version - improved for use in IN-CA
pgplot-5.2.2_27.txz C/FORTRAN library for drawing graphs on a variety of display devices
pgpmoose-1.19_1.txz PGP Moose - signatures for moderated newsgroups
pgpool-3.4.25.txz Connection pool server for PostgreSQL
pgpool-II35-3.5.22.txz Connection pool server for PostgreSQL
pgpool-II36-3.6.18.txz Connection pool server for PostgreSQL
pgpool-II37-3.7.11.txz Connection pool server for PostgreSQL
pgpool-II40-4.0.6.txz Connection pool server for PostgreSQL