AIPG

High-Performance Utilities for PostgreSQL

Advanced InfoUnload for PostgreSQL (AIPG) is a comprehensive high-performance utility for unloading PostgreSQL data.
It enables you to move your data from PostgreSQL to any data repository in a fast, easy, and smart way.

Download Now

What is AIPG?

Advanced InfoUnload for PostgreSQL is a standalone utility program that performs bulk data exports of PostgreSQL databases.

  • Unload PostgreSQL data to flat files, tape devices, or named pipes.

  • Create files for multiple targets, even if target files require different import or load file formats. InfoUnload PostgreSQL supports multiple formats for output files (XML, JSON, Delimited, Non-delimited).

  • Perform complete system migration from one PostgreSQL instance to another.

  • Eliminate the need for specific data conversion applications. InfoUnload PostgreSQL column function supports conversion to a wide range of data types with the SELECT statement.

  • Employ powerful, easy-to-use, and familiar SELECT syntax to specify columns and rows to unload.

  • Unload a PostgreSQL row sample with MAXROWS, SKIP, and INTERVAL keywords. This feature can be used to quickly check syntax in a control file.

Additionally, InfoUnload PostgreSQL provides parallel processing to maximize performance. It generates detailed summaries of unload operations, including process statistics, results, and error statements.

Why an Unload Utility?

Features pg_dump AIPG
Full Database unload ✅ ✅
Table unload ✅ ✅
SQL query based unload ❌ ✅
Transfer to a distant server ❌ ✅
Transfer to a different kind of server (NoSQL database) ❌ ✅
Flat file format support (Json, XML, delimited file) ❌ ✅
Multiple outputs ❌ ✅
Download Now

In short!

  • Ultra-fast: export data faster than any other utility

  • Multiple output formats: create files in XML, JSON, Delimited, and Non-delimited formats during a single unload

  • Selective unload: unload selected rows and columns using powerful SQL syntax

  • Data sorting: sort data during the unload process

  • Parallel processing: maximize performance by exploiting all available system processors

  • Flexible migration: perform complete system migrations or transfer data to distant or different servers (including NoSQL databases)

  • Enterprise-grade reliability: backed by Infotel Group, a European leader in enterprise digital transformation, developing software and providing IT services for over 40 years