PostgresqlのデータベーステーブルのデータをExcel形式にエクスポートする方法（推奨）

COPY { table name [ ( column name [, ...] ] ) ] | ( query ) } 
TO { 'filename' | PROGRAM 'command' | STDOUT } 
 [ [ WITH ] ( options [, ...] ] ) ]

Options can be one of the following
 FORMAT format_name 
 FREEZE [ Boolean ] 
 DELIMITER 'separator character' 
 NULL 'empty 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(encoding name)'

test=# select * from test;
user_id | user_name | age | gender | remark     
---------+---------------+-----+--------+----------------------------------------------
  1 | Jackie Chan | 45 | male | "police story","project A","rush hour"
  3 | Brigitte Li | 46 | female | 
  4 | Maggie Cheung | 39 | female | 
  5 | Jet Li | 41 | male | "Fist of Legend","Once Upon a Time in China"
  2 | Gong Li | 38 | female | "Farewell My Concubine","Lifetimes Living"
(5 lines of transcript)

test=# copy test to '/tmp/test1.csv' with csv header;
COPY 5
test=# \! cat /tmp/test1.csv
user_id,user_name,age,gender,remark
1,Jackie Chan,45,male,"""police story"","""project A"","""""rush hour"""" quot;
3,Brigitte Li,46,female,
4,Maggie Cheung,39,female,
5,Jet Li,41,male,"""Fist of Legend"","""Once Upon a Time in China"""
2,Gong Li,38,female,""""Farewell My Concubine"","""Lifetimes Living"

test=# copy test to '/tmp/test1.csv' with csv header DELIMITER '|';
COPY 5
test=# \! cat /tmp/test1.csv
user_id|user_name|age|gender|remark
1|Jackie Chan|45|male|"""police story"",""project A"",""""rush hour""& quot;
3|Brigitte Li|46|female|
4|Maggie Cheung|39|female|
5|Jet Li|41|male|"""Fist of Legend"",""Once Upon a Time in China"""
2|Gong Li|38|female|""""Farewell My Concubine"","""Lifetimes Living"

test=# copy test to '/tmp/test1.csv' with csv header null 'to be supplemented';
COPY 5
test=# \! cat /tmp/test1.csv
user_id,user_name,age,gender,remark
1,Jackie Chan,45,male,"""police story"","""project A"",""""rush hour""" quot;
3,Brigitte Li,46,female,to be supplemented
4,Maggie Cheung,39,female,to be supplemented
5,Jet Li,41,male,"""Fist of Legend"","""Once Upon a Time in China"""
2,Gong Li,38,female,""""Farewell My Concubine"","""Lifetimes Living"