How do I get the psqlodbc driver installed on MacOS?

BackwardOctopus

I'm trying to get the psqlodbc driver (https://odbc.postgresql.org/) installed on an M2 Macbook Pro in order to have JMP connect to a PostgreSQL database within my organization. I was wondering where I can find some documentation on how to do so.

So far, this link (https://odbc.postgresql.org/docs/unix-compilation.html) is all I've found and the commands under its installation instructions involve some files that aren't attached anywhere on the page. I've tried running the command 'brew install psqlodbc' and configure the relevant .ini files, but that hasn't worked either. If anyone has done this before, a rundown/link of the installation process would be greatly appreciated.

Paul_Nelson

If you are using JMP 18+ you can use the Python package psycopg to connect to PostgreSQL through Python.  

https://www.psycopg.org

I just ran the code below on my M1 Max MacBook Pro.

 

from jmputils import jpip
jpip('install', 'psycopg[binary]')
/*:
Collecting psycopg[binary]
  Downloading psycopg-3.2.6-py3-none-any.whl.metadata (4.4 kB)
Collecting psycopg-binary==3.2.6 (from psycopg[binary])
  Downloading psycopg_binary-3.2.6-cp313-cp313-macosx_11_0_arm64.whl.metadata (2.8 kB)
Downloading psycopg_binary-3.2.6-cp313-cp313-macosx_11_0_arm64.whl (3.9 MB)
   ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 3.9/3.9 MB 53.4 MB/s eta 0:00:00
Downloading psycopg-3.2.6-py3-none-any.whl (199 kB)
Installing collected packages: psycopg-binary, psycopg
Successfully installed psycopg-3.2.6 psycopg-binary-3.2.6


//:*/
import psycopg

help(psycopg)
/*:
Help on package psycopg:

NAME
    psycopg - psycopg -- PostgreSQL database adapter for Python

PACKAGE CONTENTS
    _acompat
    _adapters_map
    _capabilities
...