DE Address Full generator

Last modified: April 3, 2025

The DE Address Full generator creates complete address data based on the German (DE) address format. It generates values that mimic the typical structure of a full address in Germany. The generator ensures the data is formatted according to German address standards and includes the necessary components such as the street, postcode, and city, which are typical for German addresses.

Note

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

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
DE Address Full	Lusenstraße 21-25, 13111, Bühl; Rosental 1c, 32361, Johannstorf; …	charactercharacter varyingtext	DE

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 displays .txt files that contain a list of streets and cities. The default path to the files is C:\Users\Public\Documents\Devart\dbForge Studio for PostgreSQL\Data Generators\DEStreets.txt and C:\Users\Public\Documents\Devart\dbForge Studio for PostgreSQL\Data Generators\DECities.txt.