I am currently using ArcGIS Pro 3.0. I have a script that once worked well with ArcGIS Desktop and utilized ArcPy and psycopg2 libraries.
I understand now it is required to use propy.bat file path when trying to use stand alone scripts like below.
c:\Progra~1\ArcGIS\Pro\bin\Python\scripts\propy.bat my_script.py
When I execute my script this way I get 'No module named 'psycopg2''.
However I am confident psycopg2 is installed. I can verify this by starting python in terminal and running import psycopg2 without error.
Is there something special that needs to be done to execute a script using both libraries with ArcGIS Pro 3?