./databases/pgloader [import CSV data and Large Object to PostgreSQL]
[+] Add this package to your ports tracker

[ CVSweb ] [ Homepage ] [ RSS feed ]

Version: 2.3.2, Package name: pgloader-2.3.2
Maintained by: Pierre-Emmanuel Andre
Master sites:
Description
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.


Filesize: 84.18 KB
Version History (View Complete History)
  • (2010-04-29) Updated to version: pgloader-2.3.2
  • (2009-03-14) Updated to version: pgloader-2.3.1p0
  • (2008-06-05) Updated to version: pgloader-2.3.1
  • (2008-04-11) Updated to version: pgloader-2.3.0p0
  • (2008-04-08) Package added to openports.se, version pgloader-2.3.0 (created)
[show/hide] View available PLISTS (Can be a lot of data)

CVS Commit History:

   2015-07-18 15:11:18 by Jasper Lievisse Adriaanse | Files touched by this commit (16)
Log message:
use sed -i
   2015-02-16 15:57:14 by Christian Weisgerber | Files touched by this commit (213)
Log message:
Drop USE_GROFF from ports where the formatting differences are acceptable
or mandoc provides the more useful output.
   2015-01-17 20:16:09 by Christian Weisgerber | Files touched by this commit (3349)
Log message:
Drop remaining MD5/RMD160/SHA1 checksums.
   2011-06-08 11:33:59 by Jasper Lievisse Adriaanse | Files touched by this commit (24)
Log message:
bump after default python version switch
   2010-11-14 17:22:54 by Marc Espie | Files touched by this commit (427)
Log message:
convert to new style depends
zap default spec that are not needed
convert libspecs as well
convert p* to REVISION.
No package changes
   2010-10-18 11:06:09 by Marc Espie | Files touched by this commit (138)
Log message:
USE_GROFF=Yes
   2010-08-30 14:53:57 by Federico G. Schwindt | Files touched by this commit (20)
Log message:
Bump revision after python's default change.
   2010-04-28 12:10:03 by Pierre-Emmanuel Andre | Files touched by this commit (3)
Log message:
Update to 2.3.2
ok jasper@
   2010-04-28 12:10:03 by Pierre-Emmanuel Andre | Files touched by this commit (3)
Log message:
Update to 2.3.2
ok jasper@
   2010-04-28 12:10:03 by Pierre-Emmanuel Andre | Files touched by this commit (3)
Log message:
Update to 2.3.2
ok jasper@
   2009-03-14 06:24:48 by Marc Espie | Files touched by this commit (6)
Log message:
fix a few depends
   2008-06-05 03:45:31 by Antoine Jacoutot | Files touched by this commit (3)
Log message:
- update to pgloader-2.3.1
from Pierre-Emmanuel Andre (MAINTAINER) with some tweaks
   2008-06-05 03:45:31 by Antoine Jacoutot | Files touched by this commit (3)
Log message:
- update to pgloader-2.3.1
from Pierre-Emmanuel Andre (MAINTAINER) with some tweaks
   2008-06-05 03:45:31 by Antoine Jacoutot | Files touched by this commit (3)
Log message:
- update to pgloader-2.3.1
from Pierre-Emmanuel Andre (MAINTAINER) with some tweaks
   2008-04-10 16:42:54 by Jasper Lievisse Adriaanse | Files touched by this commit (1)
Log message:
- bump PKGNAME if DESCR is changed
   2008-04-10 16:33:19 by Ian Darwin | Files touched by this commit (1)
Log message:
Mention that it works for PostgreSQL in the first line of DESCR
(for those who overlook the COMMENT in Makefile :-)).  A few minor
wording tweaks.
OK Pierre-Emmanuel Andri (maintainer), and ajacoutot@.