Online Documentation for Data Generator for PostgreSQL
BIT field parameters
Bit strings are strings of 1's and 0's. They can be used to store or visualize bit masks. You can generate values for this field randomly, incrementally or choose to take them from a specified list of values or SQL query, or from an existing table field of the same data type.
The Generation properties panel allows you to define preferences for generating values for Bit field type.
Select Data generation mode as follows:
Generate random data
Specify the ratio between True and False values in randomly generated data.
Generate incremental data
Specify the Initial value and the Increment properties to generate an ordered incremented sequence of values. The value is incremented bit-by-bit.
Get data from list / SQL query
This panel allows you to define the list of values to generate bit data from. You can enter these values directly into the editor by selecting the List of Values option.
To add a single value, use the Add Value button.
To load a list of values from an existing external file, use the Load from file button.
To save the list to an external file, use the Save to file button.
To remove a single value, use the Delete Value button.
To remove all items from the list, use the Clear button.
You can also specify whether the values are to be taken in random order or in the order they have been inputted.
Alternatively, you can set the SQL Query option and input an SQL query into the editor, and the resulting dataset will be used as the list for data generation.
Get data from Field
This option allows you to specify a field to generate data from: use the Table and Field drop-down lists to select the source table and field that will be used to take data for generation.