New port: databases/pgloader pgloader imports data from a flat file and insert it into a PostgreSQL database table. 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. Homepage: http://pgfoundry.org/projects/pgloader/
Responsible Changed From-To: freebsd-ports-bugs->miwi I'll take it.
miwi 2008-06-03 08:38:16 UTC FreeBSD ports repository Modified files: databases Makefile Added files: databases/pgloader Makefile distinfo pkg-descr pkg-plist Log: 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 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-all@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/cvs-all To unsubscribe, send any mail to "cvs-all-unsubscribe@freebsd.org"
miwi 2008-06-03 08:38:16 UTC FreeBSD ports repository Modified files: databases Makefile Added files: databases/pgloader Makefile distinfo pkg-descr pkg-plist Log: 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 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@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/cvs-ports To unsubscribe, send any mail to "cvs-ports-unsubscribe@freebsd.org" _______________________________________________ cvs-all@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/cvs-all To unsubscribe, send any mail to "cvs-all-unsubscribe@freebsd.org"
State Changed From-To: open->closed Committed. Thanks!