Select Code to Download

psql -qX << SQL_TXT
create server if not exists temp_fs foreign data wrapper file_fdw;
...
);
copy(select * from ft_pm2 order by 2, 3) to stdout with (format csv, h
+eader true);
SQL_TXT

CAT_HEADER,SUPPLIER_CODE,CUSTOMER_CODE,F4,F5,F6,F7,F8
CAT_LINE,0001P,ABC12345,20190924,,1,Z,3.36
...
CAT_LINE,0002P,ABC12345,20190924,,1,Z,4.26
CAT_LINE,0002P,ABC23456,20190924,,1,Z,1.21
CAT_LINE,0002P,ABC34567,20190924,,1,Z,22.24