aboutsummaryrefslogtreecommitdiff
path: root/databases/pgloader/pkg-descr
diff options
context:
space:
mode:
authorMartin Wilke <miwi@FreeBSD.org>2008-06-03 08:38:16 +0000
committerMartin Wilke <miwi@FreeBSD.org>2008-06-03 08:38:16 +0000
commit6523559c07fd71e00d8231fa929b702466719476 (patch)
tree9b753255a84afda50e3fbd3ed27feea662c9ac66 /databases/pgloader/pkg-descr
parent02236a7b9970c8f7d0683499f65b2a521fbb547b (diff)
downloadports-6523559c07fd71e00d8231fa929b702466719476.tar.gz
ports-6523559c07fd71e00d8231fa929b702466719476.zip
Notes
Diffstat (limited to 'databases/pgloader/pkg-descr')
-rw-r--r--databases/pgloader/pkg-descr22
1 files changed, 22 insertions, 0 deletions
diff --git a/databases/pgloader/pkg-descr b/databases/pgloader/pkg-descr
new file mode 100644
index 000000000000..e7efa87b8332
--- /dev/null
+++ b/databases/pgloader/pkg-descr
@@ -0,0 +1,22 @@
+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/