edb_redwood_raw_names is set to its default value of
FALSE, database object names such as table names, column names, trigger names, program names, and user names appear in uppercase letters when viewed from Oracle catalogs. For a complete list of supported catalog views, see Catalog views. In addition, quotation marks enclose names that were created with enclosing quotation marks.
edb_redwood_raw_names is set to
TRUE, the database object names are displayed exactly as stored in the PostgreSQL system catalogs when viewed from the Oracle catalogs. Thus, names created without quotation marks appear in lowercase as expected in PostgreSQL. Names created in quotation marks appear exactly as they were created but without the quotation marks.
For example, the following user name is created, and then a session is started with that user:
When connected to the database as
reduser, the following tables are created:
When viewed from the Oracle catalog
edb_redwood_raw_names set to the default value
FALSE, the names appear in upper case. The exception is the
Mixed_Case name, which appears as created and also in quotation marks.
When viewed with
edb_redwood_raw_names set to
TRUE, the names appear in lower case except for the
Mixed_Case name. That name appears as created but without the quotation marks.
These names now match the case when viewed from the PostgreSQL