GBase 8s: How DELIMIDENT Controls Case Sensitivity

DELIMIDENT environment variable controls case sensitivity in GBase 8s. By default, identifiers are case-insensitive, but setting DELIMIDENT=Y enables case-sensitive table and column names. This requires exact double-quoted identifiers to match the case of the original creation. This setting is the only way to achieve case-sensitive identifiers in GBase 8s without using double quotes. It's essential to understand the implications of this setting, especially when working with existing databases.

Source →
FeedLens — Signal over noise Last 7 days