create table test_ext(
sdate date,
rtime timestamp with time zone,
)
organization external(
type oracle_loader
default directory datadir
access parameters
(
records delimited by newline
fields terminated by ';'
missing field values are null
(
sdate date "YYYY-MM-DD HH24:MI:SS",
rtime char(35) date_format TIMESTAMP WITH TIMEZONE mask "YYYY-MM-DD HH.MI.SS.FFTZH"
)
)
location ('test_extra.csv')
)
parallel 4 reject limit unlimited;
test_extra.csv
2012-04-26;2012-04-27 09:18:00.327238+08
2012-08-02;2012-08-02 12:32:43.271926+08
2012-08-02;2012-08-02 12:33:01.43135+08
2012-08-02;2012-08-02 12:33:06.920191+08
本文转自 pgmia 51CTO博客，原文链接:http://blog.51cto.com/heyiyi/1160416
