Xojo 2019r3.1 + PostgreSQL 12 at mac and the pg_hba.conf

I was fooled a while ago with this postgres nocase naming.
since then, I have all my tables and fields in lowercase.

1 Like

please keep in mind that unquoted identifiers are not case-preserving in PostgreSQL, so if you SELECT PascalCaseID FROM MyTable; the column would be returned as pascalcaseid - but as Xojo is not case sensitive itself, you can still use rs.Column("PascalCaseID").IntegerValue to access it. (It is getting nasty if there are multiple columns which names only differ in case :wink:

That, in combination with underscores is a common best practice: pascal_case_id