I'm facing an issue where keys are lowercased when parsing JSON using a Kafka source in PostgreSQL, resulting in NULL values for columns with mixed case in the JSON. How can I handle this case sensitivity in column names?
Malthe Borch
Asked on Dec 08, 2022
Example:
CREATE TABLE t ("myKey" int);