or download this
#!/bin/bash
echo "CAT_HEADER,SUPPLIER_CODE,CUSTOMER_CODE,F4,F5,F6,F7,F8
...
# echo "copy(select * from pm11107044 order by 2, 3) to stdout with (f
+ormat csv, delimiter ',', header true)" | psql -qX
or download this
./pm.pl
-- unordered data.txt:
...
CAT_LINE,0002P,ABC23456,20190924,,1,Z,2.24
CAT_LINE,0002P,ABC34567,20190924,,1,Z,2.24