如何将excel数据导入到postgresql数据库中

《如何将excel数据导入到postgresql数据库中》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、如何将Excel数据（*.xls）导入到ostgresSQL数据库中一、Excel数据（*.xls）数据文件：numbersimidlatlonspeedangletimestaternc_time4852507鑻廈0T00131.58487120.320812251.43E+09t5792015-05-0407:35:30+085107494鑻廈0T00131.55635120.293701801.43E+09t6592015-05-0407:57:38+085303724鑻廈0T00131.54643120.35

2、1403151.43E+09t7162015-05-0408:14:30+085466887鑻廈0T00131.57333120.323102251.43E+09t7602015-05-0408:28:28+085720166鑻廈0T00131.53852120.27690451.43E+09t8392015-05-0408:49:56+085762630鑻廈0T00131.53613120.2876341351.43E+09t8532015-05-0408:53:32+084616750鑻廈0T00231.5571

3、5120.307902701.43E+09t23532015-05-0407:14:50+084973998鑻廈0T00231.58148120.285302701.43E+09t25122015-05-0407:46:05+085167618鑻廈0T00231.60405120.30801801.43E+09t25932015-05-0408:02:48+085700809鑻廈0T00231.57598120.299101801.43E+09t28382015-05-0408:48:18+08二、导入步骤：1、根据

4、Excel文件另存为".csv”格式文件；2、根据Excel数据的属性创建表--Table:public.texipos--DROPTABLEpublic.texipos;CREATETABLEpublic.texipos(number0integer,simidcharactervarying(20),latnumeric,lonnumeric,speedinteger,angleinteger,time0bigint,statetext,rninteger,c_timecharactervarying(100))

5、WITH(OIDS=FALSE);ALTERTABLEpublic.texiposOWNERTOpostgres;创建表如图下所示3、打开psql.exe命令行工具4、数据导入在命令行中输入：copy数据表名称form'*.csv文件路径'withdelimater',';回车；数据导入的结果如下图所示：