PostgreSQL Python – Update Data in Table
In this article, we are going to see how to update existing data in PostgreSQL tables using the pyscopg2 module in Python.
In PostgreSQL, the UPDATE TABLE with where clause is used to update the data in the existing table from the database.
Syntax: UPDATE <table_name> SET column1 = value1, column2 = value2,….. WHERE [condition]
To execute any SQL query execute() function is called with the SQL command to be executed as a parameter.
Syntax: execute(SQL command)
Table for demonstration:
Below is the implementation:
Python3
import psycopg2
conn = psycopg2.connect(
database = "postgres" ,
user = 'postgres' ,
password = 'password' ,
host = 'localhost' ,
port = '5432'
)
cursor = conn.cursor()
sql =
cursor.execute(sql)
cursor.execute(
)
cursor.execute(
)
cursor.execute(
)
cursor.execute(
)
cursor.execute(
)
sql1 = "UPDATE Geeky SET state = 'Haryana' WHERE name = 'Radha'"
cursor.execute(sql1)
conn.commit()
conn.close()
|
Table after updating the record:
As we can see state name has been updated to Haryana where the name is Radha. It means the operation has been successfully completed.
Last Updated :
23 Sep, 2021
Like Article
Save Article
Share your thoughts in the comments
Please Login to comment...