pg_bulkload批量载入工具（初探）



安装：

# tar -zxvf pg_bulkload-3.1.6.tar.gz
# cd pg_bulkload-3.1.6
# . /home/postgres/.bash_profile
# make
# make install

引入扩展：

$ psql 
psql (9.3.4)
Type "help" for help.
postgres=# create database test;
CREATE DATABASE
postgres=# \c test
You are now connected to database "test" as user "postgres".
test=# create extension pg_bulkload ;
CREATE EXTENSION
test=# \dx
                                     List of installed extensions
    Name     | Version |   Schema   |                           Description                           
-------------+---------+------------+-----------------------------------------------------------------
 pg_bulkload | 1.0     | public     | pg_bulkload is a high speed data loading utility for PostgreSQL
 plpgsql     | 1.0     | pg_catalog | PL/pgSQL procedural language
(2 rows)
test=# \df
                                                                                                                                 List of functions
 Schema |    Name     | Result data type |                                                                                                       Argum
ent data types                                                                                                       |  Type  
--------+-------------+------------------+------------------------------------------------------------------------------------------------------------
---------------------------