Postgresql如何使得查询语句输出到文件

文本

查询结果输出到文件:

\o/tmp/a.txt

select * from table;

\o

导出成csv

COPY (select * from table) to '/u02/tmp/tmp.csv' with csv header;