postgresql copy提示datastyle的报错解决办法
程序员文章站
2022-03-24 14:01:43
当日期报错,设置日期格式
set datestyle ='iso,mdy';
copy lab4.chirpusers from stdin using delimiters...
当日期报错,设置日期格式
set datestyle ='iso,mdy'; copy lab4.chirpusers from stdin using delimiters '|'; 101|jsorp2c7|sirius|11/1/15|12 grimauld pl. london|h|4343.45|\n|0 102|8rhg2ive|lavender|08/14/2015|121 west lane, london|h|76543.5|\n|1 103|aijad9fs|padma|3/4/15|tottenham court road, london|h|45500|\n|1 104|zv67luib|lee|11/16/15|124, 41st ave west, new york|h|190000|\n|1 105|qpvlxgbq|roweena|12/28/15|112, abbey road, london|\n|300000|\n|0 106|npaelkwz|lily|12/26/15|west country, england|u|180870.56|107|\n 107|fosxeu92|james|12/26/15|\n|g|\n|106|\n 108|wf2huxig|frank|8/18/15|west london|g|36000.29|109|1 109|_hunter2|alice|8/30/15|\n|g|38987.82|108|1 110|fd9qpkoa|waldo|3/22/2016|scotland|g|7450004|\n|0 111|fd9qpkov|albus|02/22/2016|highlands, scotland|g|745697.54|\n|0 112|xzgsvzld|bill|7/4/16|charing cross road, london|g|55564.55|\n|1 113|00zn7h5f|neville|7/4/15|\n||23455|114|1 114|y8zui9ez|luna|01/22/2016|devon, england|h|9823.67|113|1 115|3wffg2im|malfoy|07/27/2015|wiltshire, england|u|32221223.88|\n|1 116|jrmiaa3n|ginny|06/29/2015|ottery st catchpole, devon|u|194649|125|1 117|gdybr39p|fred|01/31/2015|\n|l|3444334.78|\n|0 118|xezjcii2|george|09/18/2015|london|l|3534498.45|\n|1 119|krzts0wq|peter|09/27/2016|edinburgh, scotland|\n|5004|\n|0 120|jatv6mn9|petunia|01/16/2016|4 privet drive, surrey|u|9563.77|124|1 121|paxeeher|argus|4/3/15|highlands, scotland|l|29043.37|\n|1 122|taje9hrc|seamus|2/2/15|kenmare, county kerry|h|54290.7|\n|1 123|q9hy22hh|cho|\n|\n|h|4323646|\n|\n 124|xl3qpmmw|vernon|2/6/15|4 privet drive, surrey|u|55838.6|120|1 125|l0goxkmb|harry|04/21/2015|west country, england|g|\n|116|1 126|gy6x9kid|voldemort|3/8/15|london|h|85387800.89|\n|0 127|2qx5k5q9|ron|12/1/16|\n|u|74690.43|\n|1 \.
上一篇: JS: 数组乱序
下一篇: 雷军:当CEO是因为被格式化了电脑
推荐阅读
-
IE浏览器报错出现“网页上有错误”提示的解决办法
-
linux下oracle报错,提示ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务的解决办法
-
postgresql copy提示datastyle的报错解决办法
-
UG10.0提示初始化错误-15怎么办? UG报错15的解决办法
-
MacOS X Yosemite升级后postgresql启动报错的解决办法
-
linux下oracle报错,提示ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务的解决办法
-
postgresql copy提示datastyle的报错解决办法
-
MacOS X Yosemite升级后postgresql启动报错的解决办法
-
UG10.0提示初始化错误-15怎么办? UG报错15的解决办法