psql -qX << SQL_TXT
create server if not exists temp_fs foreign data wrapper file_fdw;
drop   foreign table if exists ft_pm2 cascade;
create foreign table           ft_pm2 (
    "CAT_HEADER" text
  , "SUPPLIER_CODE" text
  , "CUSTOMER_CODE" text
  , "F4" text
  , "F5" text
  , "F6" text
  , "F7" text
  , "F8" numeric
)
server temp_fs
options (
     format 'csv'
   , header 'true'
   , filename '/tmp/data.txt'
);
copy(select * from ft_pm2 order by 2, 3) to stdout with (format csv, header true);
SQL_TXT

##</code><code>##

CAT_HEADER,SUPPLIER_CODE,CUSTOMER_CODE,F4,F5,F6,F7,F8
CAT_LINE,0001P,ABC12345,20190924,,1,Z,3.36
CAT_LINE,0001P,ABC23456,20190924,,1,Z,2.14
CAT_LINE,0001P,ABC34567,20190924,,1,Z,12.23
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