On Mac M3, it turned out it didn't have anything to do with path, but rather the way that psycopg2 was installed. I had to do conda install psycopg2 instead of using pip as I was before. Thanks to this contributor for the solution.