We have a PostgreSQL instance on AWS. I would like to make a connection to the database on JMP. I installed the ODBC driver via Homebrew (I am on Mac Catalina) and set up DSN with psqlodbca.so driver. I was able to make a connection to the db successfully, but I noticed that the first 2 rows had encoding issues, so I thought that I should switch over from psqlodbca.so to psqlodbcw.so driver since the db encoding is UTF-8. When I use the psqlodbcw.so driver, it's not able to connect to the db.
