说明：copy命令用于在kingbase表和标准文件系统直接传输数据。copy命令让kingbase服务器直接读写文件，因此文件必须位于服务器本地或能被直接访问。copy只能对表进行传输。

copy命令语法：

test=# \h copy

Command:     COPY

Description: copy data between a file and a table

Syntax:

COPY table_name [ ( column_name [, ...] ) ]

    FROM { 'filename' | PROGRAM 'command' | STDIN }

    [ [ WITH ] ( option [, ...] ) ]

COPY { table_name [ ( column_name [, ...] ) ] | ( query ) }

    TO { 'filename' | PROGRAM 'command' | STDOUT }

    [ [ WITH ] ( option [, ...] ) ]

where option can be one of:

    FORMAT format_name

    OIDS [ boolean ]

    FREEZE [ boolean ]

    DELIMITER 'delimiter_character'

    NULL 'null_string'

    HEADER [ boolean ]

    QUOTE 'quote_character'

    ESCAPE 'escape_character'

    FORCE_QUOTE { ( column_name [, ...] ) | * }

    FORCE_NOT_NULL ( column_name [, ...] )

    FORCE_NULL ( column_name [, ...] )

    ENCODING 'encoding_name'

常用命令总结

1、将t11表导出

copy  t11 to '/home/postgresql/t11.csv';

2、t11表数据导出，列值以；分割

 copy  t11 to '/home/postgresql/t11.sql'  WITH delimiter ','

3、导出t11表数据，并且导出列名

copy  t11 to '/home/postgresql/t11.csv'  WITH delimiter ',' csv header;

4、导出t11表的指定列

 copy t11 (id,name) to '/home/postgresql/t11.csv' ;

5、导出t11表id<10的数据

 copy  (select id,name from t11 where id <10) to '/home/postgresql/t11.csv';

6、将t11.csv文件导入到指定的表

copy  t12 from '/home/postgresql/t11.csv';

7、将t11.csv文件(文件内容包含分隔符） 导入到t12表

copy  t12 from '/home/postgresql/t11.csv'   WITH DELIMITER ',' csv header;

8、导入含有特殊符号的文件内容到t11表中

copy t1 from '/home/kbnew/1.txt' (format csv ,DELIMITER ',');