pgloader 2.3.1_2 databases =0

Import CSV data and Large Object to PostgreSQL
Maintained by: pea@raveland.org
Port Added: 03 Jun 2008 08:39:18
License: not specified in port

---

---

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.

WWW:	http://pgfoundry.org/projects/pgloader/

CVSWeb : Sources : Main Web Site : Distfiles Availability : PortsMon

---

NOTE: FreshPorts displays only required dependencies information. Optional dependencies are not covered.
Required To Build: lang/python27
Required To Run: databases/py-psycopg2, lang/python27
There are no ports dependent upon this port

---

To install the port: cd /usr/ports/databases/pgloader/ && make install clean
To add the package: pkg_add -r pgloader

---

Configuration Options

     No options to configure

---

Master Sites:

http://pgfoundry.org/frs/download.php/1814/

ftp://ftp.FreeBSD.org/pub/FreeBSD/ports/distfiles/

- convert to using PYTHON_SITELIBDIR (not functional change)

- Move over to py25+ or above
- While here kick md5 support

Bump portrevision due to upgrade of devel/gettext.

The affected ports are the ones with gettext as a run-dependency
according to ports/INDEX-7 (5007 of them) and the ones with USE_GETTEXT
in Makefile (29 of them).

PR:             ports/124340
Submitted by:   edwin@
Approved by:    portmgr (pav)

- Update to 2.3.1

Submitted by:   Pierre-Emmanuel André <pea@raveland.org>  (maintainer via
private mail)

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.

WWW:    http://pgfoundry.org/projects/pgloader/

PR:             ports/124210
Submitted by:   Pierre-Emmanuel Andre

12 vulnerabilities affecting 17 ports have been reported in the past 14 days

^* - modified, not new

All vulnerabilities