Data Import for PostgreSQL (original) (raw)

EMS Data Import for PostgreSQL is a powerful tool to import data to PostgreSQL tables from MS Excel, MS Access, DBF, XML, TXT, CSV, MS Word, RTF, ODF, HTML. It provides adjustable import parameters, including source data formats for all the fields and destination PostgreSQL data formats for the selected fields, commit options, number of records to skip, etc.

Data Import for PostgreSQL includes a wizard, which allows you to set all the PostgreSQL import options for different files visually, and a command-line utility to execute import to PostgreSQL database in one-touch.

Key Features

Import from 10 most popular formats: MS Excel, MS Access, DBF, XML, TXT, CSV, MS Word, RTF, ODF, HTML
Importing data to one or several tables or views from different databases
Special batch insert commands allow to import data at the maximum possible speed
A number of import modes - Insert All, Insert New, Insert or Update, and others
Secure Shell (SSH) and HTTP tunneling support
UNICODE support
Adjustable import parameters for each source file
Saving all import parameters set on current wizard session
Automatic creation of the table structure
Command-line utility to import data using the configuration file
Powerful visual options module