Update multiple rows in same query in PostgreSQL using Pyscopg2-Python

Update multiple rows in same query in PostgreSQL using Pyscopg2-Python

Last Updated : 17 Oct, 2021

In this article, we are going to update multiple rows in the same query in PostgreSQL using Pyscopg2in Python.

We can update multiple values at once by using the update clause from PostgreSQL. First, we import the psycopg2 package and establish a connection to a PostgreSQL database using the pyscopg2.connect() method.

Syntax of update clause:

UPDATE "table"
SET "column_one" = value1, 
"column_two" = value2, 
"column_three" = valueN
WHERE condition;

Database Used

Below is the implementation:

Python3

import psycopg2

conn = psycopg2.connect(
    database="classroom_database",
      user='postgres', password='pass',
    host='127.0.0.1', port='5432'
)

conn.autocommit = True
cursor = conn.cursor()


sql = ''' update  student_details  set
          cgpa = 9.5 ,
          branch = 'AE'
        where student_name = 'rahul';'''

cursor.execute(sql)

sql1 = '''select * from student_details;'''
cursor.execute(sql1)

for i in cursor.fetchall():
    print(i)

conn.commit()
conn.close()

Output:

(12124468, 'arjun', 9.7, 'arjun19@gmail.com', 'CSE')
(12124469, 'DIYA', 9.4, 'diya@gmail.com', 'CSE')
(12124466, 'sarah', 9.8, 'sarah1212@gmail.com', 'CSE')
(12124470, 'priya', 8.8, 'priya@gmail.com', 'CSE')
(12124467, 'rahul', 9.5, 'rahul9@gmail.com', 'AE')

Output in PostgreSQL:

Update multiple rows in same query in PostgreSQL using Pyscopg2-Python

I

isitapol2002

Improve

Article Tags :

Practice Tags :

python

Similar Reads

Python Psycopg2 - Insert multiple rows with one query

This article is about inserting multiple rows in our table of a specified database with one query. There are multiple ways of executing this task, let's see how we can do it from the below approaches. Method 1: Inserting Values through Naive method In this method, we import the psycopg2 package and

Dynamically Update Multiple Rows with PostgreSQL and Python

In this tutorial, we will explore how to dynamically update multiple rows in a PostgreSQL database using Python. By the end of this tutorial, you'll have a solid understanding of how to write efficient Python code that interacts with PostgreSQL to update multiple rows in a database. We'll cover topi

Do loop in Postgresql Using Psycopg2 Python

In this article, we use psycopg2 to loop through all data points using psycopg2 function in Python. We will first connect our PostgreSQL database using psycopg2.connect method, and pass the connection parameters such as the host, database, user, and password. Then we will create a cursor using the c

Bulk update of rows in Postgres DB using psycopg2

PostgreSQL or Postgres is an open-source, relational, SQL complaint, database management system. It allows, the developers, to create complex applications, supporting SQL and JSON querying. It safely stores, and, scales workloads. Psycopg2 is a driver, that is used, for interacting, with Postgres da

Python Select from PostgreSQL Table using Psycopg2

This article will introduce you to the use of the psycopg2 module which is used to connect to a PostgreSQL database from Python. We will look over how to establish a connection to a database, create a cursor object to execute DBMS SQL statements, execute a SELECT statement to retrieve the data from