Member-only story

Basic SQL Operations On PostgreSQL using Python

In this article, we will learn how to connect the PostgreSQL database with Python and perform basic SQL operations in it.

Rajan Sahu
3 min readJun 23, 2022

My article is for everyone! Non-members can click on this link and jump straight into the full text!!

PostgreSQL

  • PostgreSQL is a powerful, open-source object-relational database system

Python

  • Python is a high-level, interpreted, general-purpose programming language.

Let's start working on actual tasks (चलिये शुरू करते हैं ! )

Requirements

pip install psycopg2

1. How do you a new create DATABASE in Postgres using Python.

Fig. 1

2. How do you DELETE the database from Postgres using Python.

--

--

Rajan Sahu
Rajan Sahu

Written by Rajan Sahu

Backend and Data Engineer by Day; Teacher, Friend and Content-Writer by night.

No responses yet