No module named 'psycopg2'

You are missing psycopg2 package in your Python environment!

You got error message about missing Python package. The error happens when you try to import Python module psycopg2. The Python complains that psycopg2 module can't be importend because its path is not present in your current Python path.

When using Python srcipt in your terminal your output with error message might look like this:

computer:~$

python -c "import psycopg2"

Traceback (most recent call last):
File "<string>", line 1, in <module>
ModuleNotFoundError: No module named 'psycopg2'

Are you using Python notebook? Then your code cell with error message looks similar to:

import psycopg2
---------------------------------------------------------------------------
ModuleNotFoundError Traceback (most recent call last) 
Cell In[1], line 1
----> 1 import psycopg2

ModuleNotFoundError: No module named 'psycopg2'

3 ways to fix - No module named psycopg2

Don't worry. We will fix the issue. You need to install missing package. We will show you 3 ways of how it can be fixed:

  • - install psycopg2 using pip
  • - install psycopg2 using conda
  • - automatic install of psycopg2 in MLJAR Studio

Why there are three ways to fix this issue? It all depends on which package manager are you using. The most common package manager is pip. The common choice, especially in Windows environments, is conda manager. There are also other Python package managers, for example Poetry, but we don't cover them in this article.

The last way to fix issue, is to use MLJAR Studio. It is a notebook based programming environment that can automatically detect missing Python packages and install them.

How to check if package manager is pip or conda

Are you not sure what package manager are you using? Please try the following command and if you goet the conda version displayed it means that you are using conda package manager:

computer:~$

conda --version

conda 23.11.0
If conda is missing in your environment you will get output similar to:
computer:~$

conda --version

Command 'conda' not found

Please try the below code cell if you are in Python notebook. If you get no error then you are using conda otherwise please use pip for installing new packages.

import sys
!conda list --prefix {sys.prefix}

Install psycopg2 with pip

Please run the following command to install psycopg2 with pip:

pip install psycopg2-binary

If you are using virtual environment, please make sure that it is activated.

For Python notebook users, please use the following command:

import sys
!{sys.executable} -m pip install psycopg2-binary

This will ensure that a new package is installed in Python from currently used notebook kernel. You will be able to import psycopg2 package in your notebook.

It is worth to check the PyPi website of psycopg2-binary. You can check there what is the current version and history of releases.

Install psycopg2 with conda

The psycopg2 package can be installed with the command:

conda install -c conda-forge psycopg2-binary

If you are in Python notebook, please use the following code:

import sys
!conda install --yes --prefix {sys.prefix} -c conda-forge {entry.installName}

The above code cell ensures you that psycopg2 is installed in the correct environment and will be accessable in your current notebook. Please check psycopg2-binary conda-forge website to check latest version number and history of releases.

Automatic install of psycopg2 in MLJAR Studio

MLJAR Studio is a notebook based programming environment. It offers a set of interactive Python code recipes to make coding super easy.

Each code recipe has information about required packages. If code recipe depends on psycopg2 and it is not available in Python environment then you will get the below information.

Install packages

Please install below packages to use this code recipe.

psycopg2-binary >= 2.9.9

Please wait a while for psycopg2 package installation after clicking Install package button. You will see below message:

Install packages

Please install below packages to use this code recipe.

Please wait, package installation ...

After successful installation you will get information that package is available and you can use code recipe.

Required packages

psycopg2-binary >= 2.9.9

You can focus on coding rather than fighting your python environment thanks to automatic package management.

What is psycopg2?

Psycopg2 is a popular PostgreSQL database adapter for Python, allowing Python applications to interact with PostgreSQL databases. It provides efficient ways to execute SQL queries, retrieve data, and manage database transactions. Psycopg2 is known for its stability, thread-safety, and support for advanced PostgreSQL features like asynchronous operations and notifications. It also supports connection pooling and other database optimization techniques. This library is widely used in web development and data analysis when working with PostgreSQL in Python.

Install more packages