欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

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
\.