create server pgcsv foreign data wrapper file_fdw;

create foreign table pgcsv (
   col1 int,
   col2 int,
   col3 int,
   col4 text
) server pgcsv
options ( filename '/tmp/pm-1040691.csv', format 'csv' );

select * from pgcsv; -- or a single column, of course...