Select Code to Download

# bash 

...
server fs options(delimiter'$sep',format'csv',header'TRUE',filename'$f
+ile');
SQL_PERL

create server if not exists fs foreign data wrapper file_fdw;

...
 , head3 text
)
server fs options(delimiter'|',format'csv',header'TRUE',filename'/tmp/
+flatfile.dat');

(select 'head1' "heads", array_agg(distinct head1 order by head1) "val
+ues" from flattable) union all 
...
--  head3 | {val3,val5}
-- (3 rows)