Skip to content

MoonInsung/pg_bulkload

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

pg_bulkload

pg_bulkload is a high speed data loading tool for PostgreSQL.

pg_bulkload is designed to load huge amount of data to a database. You can load data to table bypassing PostgreSQL shared buffers.

pg_bulkload also has some ETL features; input data validation and data transformation.

Branches

  • master : branch for pg_bulkload 3.1 Build Status
  • VERSION3_2_DEV : branch for pg_bulkload 3.2 Build Status

How to use

pg_bulkload works with control file like below,

$ pg_bulkload sample_csv.ctl
NOTICE: BULK LOAD START
NOTICE: BULK LOAD END
	0 Rows skipped.
	8 Rows successfully loaded.
	0 Rows not loaded due to parse errors.
	0 Rows not loaded due to duplicate errors.
	0 Rows replaced with new rows.

See documentation about detail usage.

http://ossc-db.github.io/pg_bulkload/index.html

How to build and install from source code

Change directory into top directory of pg_bulkload sorce codes and run the below commands.

 $ make
 # make install

How to run regression tests

Start PostgreSQL server and run the below command.

 $ make installcheck

About

High speed data loading utility for PostgreSQL

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages

  • C 88.1%
  • PLpgSQL 3.3%
  • SQLPL 3.0%
  • TSQL 2.9%
  • Shell 1.1%
  • Makefile 0.9%
  • Other 0.7%