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
\.
postgresql copy 提示datastyle
最新推荐文章于 2022-09-07 06:00:59 发布
当日期报错,设置日期格式
SET datestyle ='ISO,MDY';