copy 基本语法

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 [, ...] ) ]

其中 option 可以是下列之一：

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'

copy from 从指定文件读取数据

db_model_out(id,datanum,orderid,mid,outername,outtable,outfield,fieldname,datatype,fieldtype,editortype,enabled,normalfun,aggfun,defaultvalue,clearrepeat,groupby,dictcode,rsultfilter,keyword,viewfield,linkattr,remark,mtime,musername,muserid,extend1,extend2,extend3,extend4,extend5,extend6,extend7,extend8,extend9,extend10,editorwidth,colspan,required,readonly,desctype) 
from '/usr/local/cms/copydata/model_outs.csv';

copy to 将数据导出到文件

copy
(SELECT * from db_model_out where mid in (SELECT id from db_analyzemodel where id in (1000269,1000268,1000267,1000266,1000265))
) 
to '/usr/local/cms/copydata/model_outs.csv'