Programming Essentials Python - CRUD Operations - Inserting Data Into Table

In this article, we will cover how to insert data into a table using a Python-based approach. We will go through the steps involved and learn how to insert both single records and multiple records.

Key Concepts Explanation

Establishing Connection to Database

To insert data into a table, we first need to establish a connection to the database. We can achieve this by creating a connection object using Python libraries.

import psycopg2

connection = psycopg2.connect(database="your_db", user="your_user", password="your_password", host="your_host", port="your_port")

Creating Cursor Object

Once the connection is established, we create a cursor object that allows us to execute SQL queries.

cursor = connection.cursor()

Executing Query to Insert Data

We can execute a query statement using the cursor.execute method along with the data we want to insert into the table.

query = ("""
    INSERT INTO table_name (col1, col2, col3)
    VALUES (%s, %s, %s)
data = (value1, value2, value3)
cursor.execute(query, data)

Hands-On Tasks

  1. Insert one record into the table with hard-coded values.
  2. Insert one record into the table using variables for column values.
  3. Create a function to add a user to the table one record at a time.
  4. Insert multiple records (list of objects) into the table at once using executemany.


In this article, we have covered the process of inserting data into a table using a Python-based approach. By following the steps outlined and practicing the hands-on tasks, you can enhance your database manipulation skills. Feel free to experiment with different data types and scenarios to deepen your understanding.

Watch this video to further explore direct data insertion into tables using database-level operations. Happy coding!

Watch the video tutorial here