postgres COPY 问题,谢谢.

Question

pc2phone=# SELECT * from temp ;
 fdest_phone_country_code |  fdest_phone_country_name   | call_time | call_time_min |  call_cost
--------------------------+-----------------------------+-----------+---------------+--------------
 1                        | USA                         |    367234 |          6667 |   166.450000
 1808                     | USA - Hawaii                |       748 |            16 |     0.608000
 20                       | Egypt                       |       667 |            20 |     3.024000
 212                      | Morocco                     |       314 |            10 |     2.320000查询的时候,看到表结构很工整,我准备将 temp 表导出,执行 COPY temp TO '/home/postgres/123.csv' with csv; 导出后发现少了最上面一行:
1 USA 367234 6667 166.45
1808 USA - Hawaii 748 16 0.608
20 Egypt 667 20 3.024
212 Morocco 314 10 2.32
2126 Morocco - Mobile [phone]
221 Senegal 376 7 1.484
223 Mali 12 1 0.254请问各位高手,如何解决?谢谢.

Answer 1

没有少啊只是你没有COPY表的HEAD
试试：
COPY temp TO '/home/postgres/123.csv' with csv header;