,0,1,2,3,4,5,6
0,1,1,1,76.0,2.99,2005-05-25 11:30:37.000,2019-04-11 18:11:50
1,2,1,1,573.0,0.99,2005-05-28 10:35:23.000,2019-04-11 18:11:50
2,3,1,1,1185.0,5.99,2005-06-15 00:54:12.000,2019-04-11 18:11:50
3,4,1,2,1422.0,0.99,2005-06-15 18:02:53.000,2019-04-11 18:11:50
4,5,1,2,1476.0,9.99,2005-06-15 21:08:46.000,2019-04-11 18:11:50
5,6,1,1,1725.0,4.99,2005-06-16 15:18:57.000,2019-04-11 18:11:50
你好,我想知道如何插入这个逗号分隔的文档到postgresql。文档的详细信息如上所示。
我知道时间戳需要像这样插入“2019-04-11 18:11:50”。但我不想为所有时间戳值添加“”。
我想插入的数据类型的顺序,细节如下.
integer, integer, smallint, smallint, integer, numeric, integer,
timestamp without time zone, timestamp without time zone
请告诉我。
1条答案
按热度按时间mwkjh3gx1#
How can I import TIMESTAMP into POSTGRES without seconds? Coming from large CSV
https://www.youtube.com/watch?app=desktop&v=6Jf7eTkIaR4