PostgreSQL 数据库之拷贝CSV至PostgreSQL数据库中

DROP TABLE IF EXISTS "BH"."BHpointxx";
CREATE TABLE "BH"."BHpointxx" (
    ShipName TEXT,
    IMO varchar(60) ,
    ShipTypeEN TEXT,
    Speed TEXT,
    Lon TEXT,
    Lat TEXT,
    Dest TEXT,
    ETA TEXT,
    UnixTime TEXT,
    Lon_d TEXT,
    Lat_d TEXT
    );


COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_2d92d9956685aa67b07108db3a396f79-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_2dfda24b18effcee6d47c7748bd0c5a5-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_31019375f16eb943c99373e2517fcc22-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_325792ddf61dd57de7d05bbc8eef9415-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_33edcfbca02a017968be340464935e57-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_37bdc2853309fe4141c09324ce2b83dd-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_386ad435c49a778ed994dba23f69bdce-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_3991f3b3c7fc0113a8bae63fe3c6a7ad-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_39ecd88c7b655ed79576d92e571da007-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_3a86997edbbbb67d6b3fac0315ce85f8-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_3a9f2e78ef589c914b121e9b11aaaad3-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_3d18d85c63d55f552f0f94162529f7a2-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_3f1e97de27b316c48d69b38d665eb5bf-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_435b29fe505981a6a5fa73e441b0e652-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_4486acea3cf9a689eb84c4b99621376c-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_452969dbab08bc8301bc6085340d3254-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_4531205c17bd4079ca130b2092a4a8a7-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_462b9f3d93223e9069e734845eb0e9d3-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_5200e875f0945d0c0c919343a7f14226-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_54f81e09b19f26f09125283462d9c96e-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_5beee0d5172cc3d1096fcb0fef220d4a-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_5c5517df828432f4a77b7efe5fe5bd64-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_5da992db8602a3d0ef34b67a0d5eea8e-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_62bc1a340cf04af1a6c8c5f3320242a4-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_6363a31528e1d57225dc2066e0dacfe5-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_69fd243a9016a9fb41363a98d8b773f0-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_6d164ae280672b2d6626bb29efab9a17-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_7384dc20a550d85595e8a6af45c1a71a-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_74684347f8c984955bbfdf46e933b2c0-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_74c02dd4bf8de000436ea3298f030e86-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_79381aefca2b795810220d447598f287-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_7bcedac9caffb703b95ff07512e9b3be-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_7bf40ef46a1435f47c6d3fb8e052ef60-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_7cccfb71b52ff94e8c7744256f9bc42c-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_7daa8e0a65f749b09f37df0272314002-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_7dad08d54cd8ec161389b20befb87c51-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_83be5e14923f35097fe18a4186f8f0bd-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_85c07b7b68d6025724abfd7cf9507377-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_8767d82ff2372ec781ad85af4b842f01-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_87988cbfb0c999063810b56a0297251f-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_8b7b10e9e5227a4bc2d7820e5a3f68ee-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_8c333dd366d21eac04c5f6764befc0b1-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_8dab90668f6b9aa22be2542a23bf2cef-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_8edcfa348062c83702c0f6ef48ac6e6c-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_8edf2f3b80e154927e80705f11de1190-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_8f3f439adce68a8c59e3b4108ff24406-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_916ed220dde78995df857b1dc85ebe07-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_95dc19fc294e803c42827661b51839de-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_9772dc41ec7441707ac4ec850679cd8e-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_99bf900e55687307120ab79cd371e7fc-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_9bf6c9fbbc810df237ed6a58ed203a21-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_9d0c3145b44fe9fe5a9cb9149415a83a-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_9edfb24fa2e8c024874094f12ab4a0ea-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_9fc6d4673f80c12e5568dad5d2009f67-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_a4f76defb2aa06b5f4d2a6ee6a0d0fca-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_a588841b6354a7027a0fa7bc16567e3e-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_a7494fb2ee3ae3b33544b25b32ca5b66-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_a8aac36aead484380f8baef88f5af78a-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_a8ee1c421b996583de21ef362c172f77-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_a995f159027d5c9f7129f924aa479f02-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_ad82869016d66ee8ef0d1c86c5854f27-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_aef8b8a2fd2519da55760d7a0b3ccb8d-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_b412b57d9a9bd01ec3e85c395e34e3ea-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_b468e0c982b58234364b4c1999e29cfe-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_b52b64fa789490c48e1b2d0e9c28659e-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_b554bb9960dd9994324c3d2fd2fb342d-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_b81eef521798621dd85c2a81104ac34d-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_b82152d2704811c978775342da671091-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_b919632ee642e5c5b7f4752f5cb028f7-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_ba0f04676146ed60e84e8f2be8b03ee9-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_be8eef99356eaf8f59c15d8b18e9fb3a-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_beacf6cd25d327203c35fd39efa578b2-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_c68732b0aad1ee6c7cb55ce33fe1d8ce-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_c71099047acf70a828fb60ea15a4b6e3-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_c76063262e2a566a601f402d2d5cf60c-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_c76bdf6cce5ac1f23614b4226670a1c8-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_c7953e7de1c13c5cb6bc3b0d4a7d58ce-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_c9b5ac6d61ce34467fafeae9ad0ad90b-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_ca38785d0b2d7cd3a727c45418d4fc14-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_ccb2f15dad9e0da62cb964a00ca0ee52-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_cd56bbad2bb1e1501969d4414fec589a-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_ce547e23a6f48217703a4a32a55ffe24-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_d1e7c6d69058e57f493e478c57bbca24-2019-07.csv' CSV HEADER;
COPY "BH"."BHpointxx" FROM  'D:\CSV_sateg03\JS_03\stage02_new_CSV_d3394c24b6123d8ba4382f8630407529-2019-07.csv' CSV HEADER

select * from "BH"."BHpointxx"

会使用 SQL 声明变量 循环写入 的 朋友请积极评论