cvs commit: ports/databases Makefile ports/databases/pgloader
Makefile distinfo pkg-descr pkg-plist
miwi at FreeBSD.org
Tue Jun 3 09:37:10 UTC 2008
miwi 2008-06-03 08:38:16 UTC
FreeBSD ports repository
databases/pgloader Makefile distinfo pkg-descr pkg-plist
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
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.
Submitted by: Pierre-Emmanuel Andre
Revision Changes Path
1.681 +1 -0 ports/databases/Makefile
1.1 +44 -0 ports/databases/pgloader/Makefile (new)
1.1 +3 -0 ports/databases/pgloader/distinfo (new)
1.1 +22 -0 ports/databases/pgloader/pkg-descr (new)
1.1 +59 -0 ports/databases/pgloader/pkg-plist (new)
cvs-ports at freebsd.org mailing list
To unsubscribe, send any mail to "cvs-ports-unsubscribe at freebsd.org"
More information about the cvs-all