UK County generator

The UK County generator creates the names of counties in the United Kingdom. It generates realistic and valid county names, which are used in postal addresses and geographical data, suitable for testing, development, or training purposes where UK-specific regional information is needed.

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 County 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 County Moray, West Lothian, Shetland, … character
character varying
text		 GB

Matching rules

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

  • The column name ends with ‘County’, preceded by any or no characters, regardless of the table name.
  • The column name contains ‘Addr’, preceded or followed by any or no characters, and ends with ‘3’, regardless of the table name.

Configure additional options

The tool allows you to set additional options:

  • In the File to load data from box, select … to choose a file to load data from. The default path to the file that stores a list of counties is C:\Users\Public\Documents\Devart\dbForge Studio for PostgreSQL\Data Generators\UKCounties.txt.
  • Select the Trim left trailing spaces checkbox to remove spaces, tabs, and other non-printing characters on the LEFT of each string.
  • Select the Trim right trailing spaces checkbox to remove spaces, tabs, and other non-printing characters on the RIGHT of each string (does not remove line breaks).

Preview of the column data generated by the UK County generator

UK County generator