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

[Jean-Yves_Pochez]

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

[Tobias_Bussmann]

@MarkusR

in ms sql i can use Pascal Casing at design with few exceptions. (reserved words need brackets in query.)

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

@Jean-Yves_Pochez

since then, I have all my tables and fields in lowercase.

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