Department generator

The Department generator creates data related to departments within an organization. This data can be used for testing, development, or training purposes.

Generator properties

The table provides key details about the data generator, including the short name, sample of the generated data, the supported data types, and whether it is specific to a particular country.

Short name	Sample of generated data	Data type matching	Country-specific
Department	Marketing, Finance, Research and Development, Manufacturing, Sales, Customer Support	character varying character text	Default

Matching rules

The generator can be assigned to a column that matches any of the following rules:

• The column name is ‘name’, and it belongs to a table whose name is ‘department’.
• The column name is ‘department’, and it can belong to a table with any name.
• The column name is ‘dname’, and it belongs to a table whose name is ‘dept’.

Configure additional options

The generator produces data based on a regular expression. Since it is built on the RegExp generator, see Regular Expression generator to customize settings and understand the correct usage of syntax.

The Text box displays a file with the default list of job titles. The file is stored at C:\Users\Public\Documents\Devart\dbForge Studio for PostgreSQL\Data Generators\JobTitles.csv.

Preview of the column data generated by the Department generator