fzpgloader
FasterZip PostgreSQL Loader - ETL for postgresql FasterZip PostgreSQL
... the JRE course) To make SQL on the source file, keep in mind: 1) The file will be played under the name "origin" 2) If the option encCol1era, not in the configuration file or encCol1era = 0, the columns are automatically named file like this: col1, col2, ... coln, and the SQL touches take these names. If the option encCol1era = 1, the first line of the file will be taken into consideration as headings for each field.
Look the wiki for more information