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.
Comments
0 comments
Please sign in to leave a comment.