US State generator
The US State generator creates the full names of U.S. states and territories (e.g., California, Texas, New York). This data is usually used for geographic identification, addressing, and regional categorization in applications and datasets.
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 |
|---|---|---|---|
| US State | New York, Indiana, … | character character varying text |
Default |
Matching rules
The generator can be assigned to a column that matches any of the following rules:
- The column name is ‘State’, regardless of the table name.
- The column name starts with ‘Addr’ and ends with ‘3’, ‘4’, ‘5’, or ‘6’, with any or no characters in between, regardless of the table name.
- The column name is ‘name’, and it belongs to a table whose name contains ‘State’ or ‘Province’, preceded or followed by any or no characters.
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 .csv file that contain a list of state codes. The default path to the file is C:\Users\Public\Documents\Devart\dbForge Studio for PostgreSQL\Data Generators\USStateCodes[1].csv.
Preview of the column data generated by the US State generator
