Datanamic Data Generator for PostgreSQL

Generate realistic test data fast...

Automated Test Data Generation For PostgreSQL Databases

postgresql test data
  • Generate meaningful test data
  • Populate database directly or generate insert scripts
  • Generates data that is appropriate for the database schema
  • Support for PostgreSQL version 7,8 and 9
  • Customize data generators (if desired)
  • Large collection of predefined (country/language specific) generators
  • Create user defined data generators
  • Project oriented architecture

Whether you are developing a new PostgreSQL database application from the ground up or prototyping to prove a concept, you need test data to run your application against. To test an application’s performance effectively, you should have enough test data to expose potential database performance problems. Datanamic Data Generator for PostgreSQL comes with features that will help you generating meaningful test data for your PostgreSQL database quickly.

The tool generates realistic data that is appropriate for the database schema (with referential integrity support). The data can be inserted in the database directly or you can generate a SQL script with insert statements.

You define a data generation plan that specifies the details of how you want data to be generated for specific tables and columns. For each column, the tool chooses an appropriate data generator that produces data of a particular type. Note that you can always select another data generator if you want. Datanamic Data Generator for PostgreSQL includes more than 40 built-in data generators for generating different kinds of data. You can create your own data generators also.
You can save time by using Datanamic Data Generator for PostgreSQL to generate test data. You don't have to create your test data manually anymore. When your underlying database changes, the tool detects that and automatically chooses appropriate data generators so that you don't have to start all over again. To further automate your test data generation process, you can use the included command-line utility.
A large number of data generators to choose from, an intuitive user interface and intelligent association of columns with an appropriate data generator. Test data generation with Datanamic Data Generator for PostgreSQL is easy and painless.


Datanamic Data Generator for PostgreSQL is a database tool to generate test data for your PostgreSQL databases. It inserts generated data directly into the database, or builds insert SQL statements.

  • Direct access to PostgreSQL databases (with native driver).
  • Supported PostgreSQL versions: 7,8 and 9.
  • Generates data that is appropriate for the database schema.
  • Intelligently chooses appropriate data generator for each column (can be customized if desired) based on column's characteristics.
  • More than 40 (country and language specific) built-in data generators.
  • Load random data from external sources.
  • Load random data from already existing data sources such as other tables.
  • Option to disable triggers and foreign keys.
  • Realtime preview of data that will be generated.
  • Generates realistic data with intelligent use of the expression/mask generator (for for example postal codes) and a large collection of lists with names, addresses, cities, streets, etc.
  • Generate test data for a complete database or for a selection of tables.
  • Command-line utility to further automate your data generation process is included.
  • Create your own user defined data generators.
  • Insert data directly into the database or generate a SQL script with insert statements.
  • High performance with thousands of inserts per second.
  • Setting to define the percentage of null values.
  • Setting to specify how many times a generated value must be used. Useful for master-detail data. e.g. A customer must have at least 5 orders but not more than 10.
  • Referential integrity support.
  • Save your test data generation plan to a project file.
  • Extensive validation of data generator settings.
  • Execute pre/post data generation scripts.
  • Automatic detection of changes in your database schema.
  • Generate unique values option.


Select a data generator you want to use for a field.

Preview data that will be generated.

Edit named generators.

Start generating test data.

Generating test data.

Edit project settings.


Datanamic Data Generator for PostgreSQL costs $ 499 for a single user license (EULA).

Upgrade Protection/Support is optional and costs 20% of the initial purchase price per year.

Or upgrade

Tech specs

Operating System: Windows 10/8.1/8/7/Vista/XP

Memory: 1 GB minimum (2 GB recommended)

Hard Disk: At least 20 MB of free disk space

Try Datanamic Data Generator for PostgreSQL for free

Download a 14-day free trial, and generate data for your test database in a couple of clicks.

Save with Bundles

If you buy our software in bundles you save a great deal of money on the price of the individual database tools.