postgre 导出单表和导入

COPY user TO '/tmp/data/test.csv' WITH csv;
COPY user(name,password) TO '/tmp/data/test.csv' WITH csv;
COPY (select * from user) TO '/tmp/data/test.csv' WITH csv;
COPY (select name,age from user) TO '/tmp/data/test.csv' WITH csv header;

COPY { table_name [ ( column_name [, ...] ) ] | ( query ) }
    TO { 'filename' | PROGRAM 'command' | STDOUT }
    [ [ WITH ] ( option [, ...] ) ]

COPY user_1 FROM '/tmp/data/test.csv' WITH csv;

COPY table_name [ ( column_name [, ...] ) ]
    FROM { 'filename' | PROGRAM 'command' | STDIN }
    [ [ WITH ] ( option [, ...] ) ]