If the connection is successful the script will print the database version and if not will throw an error and print the exception message on the console. Remember to give the correct path where the local.env is created.Īdd the following code to the python script which will connect to the postgresql with the help of the psycopg2 module. The script will import the configparser module for reading the configuration file. You are free to change these details as per your configuration setup.Ģ.2 Creating a python script to read the configurationĪdd the following code to the python script which will read the configuration file created above and return the config object to be used later while connecting to the database.

2.1 Creating a configuration fileĪdd the following code to the environment file wherein we will specify the connection and database details. Let us dive in with the programming stuff now.

database – Database to which you want to connect.

If running on localhost then you can either use localhost or 127.0.0.1

host – Address of the database server.

password – Credential of the identity user.

user – Identity user to work with the PostgreSQL database.

For further information on docker basics, you can navigate to this tutorial.įor the psycopg2 module to work we will supply the following attributes to the PostgreSQL from the python application i.e. You can use the docker ps -a command to confirm that container is started successfully. If everything goes well the container would be started successfully as shown in Fig. You can execute the below command to get the container running on docker in minutes.ĭocker command docker run -d -p 5433:5432 -e POSTGRES_PASSWORD=password -name postgres postgres For easy setup, I have the database up and running on the Docker environment. To start with the tutorial, I am hoping that you have the Postgres up and running in your localhost environment.

Installation command pip install psycopg2 You can fire the below command from the command prompt and it will successfully download the module from and install it. Once the python is successfully installed on your system you can install the psycopg2 using a simple pip command. You can download the Python from this link.

If someone needs to go through the Python installation on Windows, please watch this link. To connect with PostgreSQL in python programming we have the following modules that are commonly available and known to the developer world as all these modules adhere to the Python database API specification – Hello in this tutorial, we will understand how to perform SQL – Crud operations to the PostgreSQL database via python programming.

Crud flask sqlite