pgloader 支持多种数据源数据的加载，以下列出简单的操作命令，后边会有详细的使用说明

csv 格式内容加载

预备说明

需要先在pg 数据库创建表

create table districts_longlat

         usps text,

         geoid text,

         aland bigint,

         awater bigint,

         aland_sqmi double precision,

         awater_sqmi double precision,

         intptlat double precision,

         intptlong double precision

);

请求格式

pgloader --type csv \

         --field id --field field \

         --with truncate \

         --with "fields terminated by ','" \

         ./test/data/matching-1.csv \

         postgres:///pgloader?tablename=matching

pgloader --type csv \

         --field "usps,geoid,aland,awater,aland_sqmi,awater_sqmi,intptlat,intptlong" \

         --with "skip header = 1" \

         --with "fields terminated by '\t'" \

- \

         postgresql:///pgloader?districts_longlat \

         < test/data/2013_Gaz_113CDs_national.txt

pgloader --type csv \

         --field "usps,geoid,aland,awater,aland_sqmi,awater_sqmi,intptlat,intptlong" \

         --with "skip header = 1" \

         --with "fields terminated by '\t'" \

         http://pgsql.tapoueh.org/temp/2013_Gaz_113CDs_national.txt \

         postgresql:///pgloader?districts_longlat

curl http://pgsql.tapoueh.org/temp/2013_Gaz_113CDs_national.txt.gz \

| gunzip -c \

| pgloader --type csv \

           --field "usps,geoid,aland,awater,aland_sqmi,awater_sqmi,intptlat,intptlong"

           --with "skip header = 1" \

           --with "fields terminated by '\t'" \

- \

           postgresql:///pgloader?districts_longlat

createdb newdb

pgloader ./test/sqlite/sqlite.db postgresql:///newdb

createdb pagila

pgloader mysql://user@localhost/sakila postgresql:///pagila

createdb foo

pgloader --type dbf http://www.insee.fr/fr/methodes/nomenclatures/cog/telechargement/2013/dbf/historiq2013.zip postgresql:///foo

实际上官方代码仓库包含了一个test 的目录，里边包含了测试脚本以及数据