-
Enhancement
-
Resolution: Unresolved
-
Major
-
2.7.0.Final
-
None
-
False
-
None
-
False
-
-
When streaming changes across database vendors, users may want to avoid the use of quote.identifiers in some situations and would rather have the columns and tables created based on the normal semantics of the database, i.e.:
PostgreSQL - table and column names default to lower case
Oracle and Db2 - table and column names default to upper case
So if a user were to replicate from PostgreSQL to Oracle for example, using quoted.identifiers is the only solution to guarantee that the column and table name lookups work between the two database vendors due to their default case semantics.
These additional strategies are meant to help users who would rather in the PG to Oracle case, have the tables and columns created in upper-case using default semantics without quoted identifiers. This would allow any other application or user to query the tables without mandatory use of quotes when interacting with the tables on Oracle.