edb_redwood_raw_names v12
When 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, user names, etc. appear in uppercase letters when viewed from Oracle catalogs (for a complete list of supported catalog views, see the Database Compatibility for Oracle Developers Catalog Views Guide). In addition, quotation marks enclose names that were created with enclosing quotation marks.
When edb_redwood_raw_names
is set to TRUE
, the database object names are displayed exactly as they are stored in the PostgreSQL system catalogs when viewed from the Oracle catalogs. Thus, names created without enclosing quotation marks appear in lowercase as expected in PostgreSQL. Names created with enclosing 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, USER_TABLES
, with edb_redwood_raw_names
set to the default value FALSE
, the names appear in uppercase except for the Mixed_Case
name, which appears as created and also with enclosing quotation marks.
When viewed with edb_redwood_raw_names
set to TRUE
, the names appear in lowercase except for the Mixed_Case
name, which appears as created, but now without the enclosing quotation marks.
These names now match the case when viewed from the PostgreSQL pg_tables
catalog.