Full Name generator

Last modified: April 3, 2025

The Full Name generator creates complete, realistic names that include all the components typically associated with a full personal name. A full name generally consists of the first name, middle name (optional), and last name (surname).

Generator properties

The table provides key details about the 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 Example of generated data Data type matching Country-specific
Full Name Malik Whitmore, Sherill Gaskin, … character varyingcharactertext Default

Matching rules

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

  • The column name starts with ‘created’, ‘modified’, ‘locked’, or ‘updated’ and ends with ‘by’, with any or no characters in between, regardless of the table name.
  • The column name starts with ‘name’ and ends with ‘full’, with any or no characters in between, regardless of the table name.
  • The column name starts with ‘full’, ‘contact’, ‘reviewer’, ‘card’, or ‘ship’ and ends with ‘name’, with any or no characters in between, regardless of the table name.
  • The column name is ‘contact’, regardless of the table name.
  • The column name contains ‘artist’ or ‘composer’, preceded or followed by any or no characters, regardless of the table name.

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 .txt files that contain a list of male and female first and last names. The default path to the files is:

  • C:\Users\Public\Documents\Devart\dbForge Studio for PostgreSQL\Data Generators\FirstNamesMale.txt.
  • C:\Users\Public\Documents\Devart\dbForge Studio for PostgreSQL\Data Generators\FirstNamesFemale.txt.
  • C:\Users\Public\Documents\Devart\dbForge Studio for PostgreSQL\Data Generators\LastNames.txt.

Preview of the column data generated by the Full Name generator

Full Name generator