PostgreSQL installation and import to Python

Hi,

I’ve downloaded and installed the following (Version 12,1 for Windows);

Also have the Anaconda Navigator installed (see the screenshot attached.

Where I should do the following instruction from the mission exactly?
You can install this library using Anaconda:
conda install psycopg2

And how should I launch my python shell? Should I launch Spyder?
Launch your Python shell and import the psycopg2 library. Then, run the following code to connect to PostgreSQL and test that everything works as expected:

Hi @hakobiantigran

Welcome to our Dataquest Community.

Go through the below post, where you get how to install PostgreSQL and start the database.

And then Launch the Jupyter which is shown in ANACONDA NAVIGATOR and start writing your code.

You can install the psycopg2 library using Anaconda Prompt.

I hope this helps.

2 Likes