Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-8016

Introduce a lower-case and upper-case column/table naming strategies

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Unresolved
    • Icon: Major Major
    • 3.1-plan
    • 2.7.0.Final
    • jdbc-connector
    • 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.

            ccranfor@redhat.com Chris Cranford
            ccranfor@redhat.com Chris Cranford
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: