postgresql copy提示datastyle的报错解决办法

当日期报错，设置日期格式

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