Table generation settings
Last modified: April 3, 2025
After you set up options and opened the data generation project, you can select the tables to populate with data and configure table generation settings that are displayed on the right pane of the Data Generation project.
Available configurations
Row distribution mode section
Here you can specify the volume of data you want to generate as follows:
- Specify the number of rows
- Specify the proportion of existing data
- Define a period of time for which data will be generated
- Specify the proportion of the lookup table (click an arrow to select a lookup table from the list)
The Truncate data from table before generation checkbox is selected by default. If you don’t want the selected table to be truncated, clear the checkbox.
Related tables section
Here you can see a list of the tables related to the table you selected for population. The related tables are divided into two groups: Parent tables and Child tables.
Note
A parent table is the table that stores the primary key. A child table is a table that references the parent with a foreign key. Data population may fail if you do not include the related tables in data generation.
Data Generator will notify you if you try to populate the columns that refer to the table, whic is not included in data generation.
To include the related tables in data generation, select the checkboxes in the Related tables section.
Want to find out more?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for PostgreSQL.
All features
Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.
Request a demo
If you consider employing this tool for your business, request a demo to see it in action.