Binary package “pgloader” in ubuntu trusty
loads flat data files into PostgreSQL
pgloader imports data from flat files and insert it into a database
table. You have to provide a configuration file containing sections,
which each defines how to load a table. CSV and text format are
supported, the former is able to import MySQL dumps when -T is used,
the latter is able to parse multi-line non-quoted with trailing
delimiter quite CSV input, such as given by Informix UNLOAD.