1、写入文件命令:
\o /home/write.txt
接下来执行query命令:
select rs.* from (select * from test where rate > '17%') rs limit 1;
执行的结果将自动写入到文件write.txt中,但是每一行第一个字符是空格
2、使用copy to
COPY (select * from test where rate > '17%') TO '/home/query.csv' (format csv,delimiter ';')