Handling table and column names with spaces and special characters when working with databases

By default, Etlworks Integrator will enclose table or column names in [databases specific] quotes if it contains a space or starts with a number.

Examples (PostgreSQL)

• patient -> patient
• 2patient -> "2patient"
• First Name -> "First Name"

Examples (MySQL)

• patient -> patient
• 2patient -> `2patient`
• First Name -> `First Name`

Sometimes it makes sense to enforce the enclosing to automatically handle edge cases such as:

• A name contains a reserved SQL keyword, for example FROM, SELECT, etc.
• A name contains special character, for example ., ;, etc.

When the enclosing is enforced all names will be enclosed in [databases specific] quotes:

• public.patient -> public."patient"
• First Name -> "First Name"

To enforce the enclosing for all objects when configuring the database connection simply enable the option Always enclose table/column names in double quotes.