cvs commit: ports/databases Makefile ports/databases/pgloader Makefile distinfo pkg-descr pkg-plist

Martin Wilke miwi at
Tue Jun 3 09:37:10 UTC 2008

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 
  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.
  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 at mailing list
To unsubscribe, send any mail to "cvs-ports-unsubscribe at"

More information about the cvs-all mailing list