I think you can guess what I am doing CREATE EXTENSION file_fdw; CREATE SERVER pglog FOREIGN DATA WRAPPER file_fdw; CREATE FOREIGN TABLE temp_history_temp ( itemid bigint, clock integer, value DOUBLE PRECISION, ns integer) SERVER pglog OPTIONS ( filename '/tmp/history.csv', DELIMITER ',', FORMAT 'csv');