PostgresQL Row and case sensitivity

[ronnybremer]

While migrating an existing SqlX app from MySQL to PostgresQL I noticed, that PostgresSQL converts all column names to lowercase, if not enclosed in quotes during table creation. This behavior leads to a major change throughout the code, as it requires all row retrieval sections to be adopted. For example:

let guid: String = row.get("GUID");

Needs to become:

let guid: String = row.get("guid");

Wouldn't it make sense to do a case-insensitive lookup inside of Postgres/row.rs (fn index()) by default?

Thank you for your feedback.