UK Address Full generator

The UK Address Full generator creates UK-style addresses in a single field. These addresses usually include all key components of a UK address, including Building name or number, Street name, Postcode, etc.

Note

If you select United Kingdom from the Country-specific data list on the Options page of the Data Generator Project Properties wizard, the UK Address Full generator will be applied to columns that meet the matching rules, replacing the default (United States) generator.

UK country specific data

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
UK Address Full 252A Mayville Road, Ipswich, Moray BB41 9EP; … character
character varying
text		 UK

Matching rules

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

  • The column name is ‘Address’, regardless of the table name.
  • The column name contains ‘Full’, preceded or followed by any or no characters, and ends with ‘Addr’, regardless of the table name.
  • The column name contains ‘Addr’, preceded or followed by any or no characters, and ends with ‘Full’, 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 .txt files that contain a list of streets, cities, and counties. The default path to the files is:

  • C:\Users\Public\Documents\Devart\dbForge Studio for PostgreSQL\Data Generators\UKStreets.txt
  • C:\Users\Public\Documents\Devart\dbForge Studio for PostgreSQL\Data Generators\UKTowns.txt
  • C:\Users\Public\Documents\Devart\dbForge Studio for PostgreSQL\Data Generators\UKCities.txt
  • C:\Users\Public\Documents\Devart\dbForge Studio for PostgreSQL\Data Generators\UKCounties.txt

Preview of the column data generated by the UK Address Full generator

UK Address Full generator