FasterZip PostgreSQL Loader - ETL for postgresql FasterZip PostgreSQL
This is a Java application that lets you filter the information into a file before loading using a copy (psql does not require). Use a configuration file for the data connection to the db, source file and special parameters. You can make SQL (using HSQL) the source file, allowing the transformation of data prior to loading. Can run on any OS that use Java without needing to install any additional components (other than 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
- SQL to file
Thanks for Fzpgloader, it's great!
Thanks you! Please look others projects of my account.