diff options
author | Martin Wilke <miwi@FreeBSD.org> | 2008-06-03 08:38:16 +0000 |
---|---|---|
committer | Martin Wilke <miwi@FreeBSD.org> | 2008-06-03 08:38:16 +0000 |
commit | 6523559c07fd71e00d8231fa929b702466719476 (patch) | |
tree | 9b753255a84afda50e3fbd3ed27feea662c9ac66 /databases/pgloader/pkg-descr | |
parent | 02236a7b9970c8f7d0683499f65b2a521fbb547b (diff) | |
download | ports-6523559c07fd71e00d8231fa929b702466719476.tar.gz ports-6523559c07fd71e00d8231fa929b702466719476.zip |
Notes
Diffstat (limited to 'databases/pgloader/pkg-descr')
-rw-r--r-- | databases/pgloader/pkg-descr | 22 |
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/ |