US Address Full generator
The US Address Full generator creates complete and realistic full addresses within the United States. This includes all components of an address, such as the street address, city, state, and ZIP code, formatted according to US postal standards. It is useful for populating databases, testing address-related systems, or simulating scenarios that require complete US addresses.
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 Address Full | 520 46th St, Sacramento, CA, 10265; … | 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 contains ‘Address’, preceded or followed by any or no characters, regardless of the table name.
- The column name contains ‘Address’, preceded or followed by any or no characters, and ends with ‘1’, regardless of the table name.
- The column name ends with ‘street’, preceded 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 also displays .csv files that contain a list of state codes. The default path to the files is C:\Users\Public\Documents\Devart\dbForge Studio for PostgreSQL\Data Generators\USStateCodes.csv.
Preview of the column data generated by the US Address Full generator
