There is a possibility that you have two versions of python installed and python2-pip is aliased as pip while python3-pip is aliased as pip3.
Make sure you are using right version with python and pip.
So the command would be:
pip3 install psycopg2
