Python PostgreSQL – Delete Data
In this article, we are going to see how to delete data in tables from PostgreSQL using pyscopg2 module in Python. In PostgreSQL, DELETE TABLE is used to delete the data in the existing table from the database. It removes table definition and all associated data, indexes, rules, triggers, and constraints for that table. If the particular table doesn’t exist then it shows an error.
Table Used:
Here, we are using the accounts table for demonstration.
Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.
To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course. And to begin with your Machine Learning Journey, join the Machine Learning - Basic Level Course
Now let’s drops this table, for we will use will psycopg2 module to connect the PostgreSQL and execute the SQL query in cursor.execute(query) object.
Syntax: cursor.execute(sql_query);
Example 1: Deleting all the data from the table
Here we are deleting all the table data using DELETE clause.
Syntax: DELETE FROM table_name
Code:
Python3
# importing psycopg2import psycopg2 conn=psycopg2.connect( database="geeks", user="postgres", password="root", host="localhost", port="5432") # Creating a cursor object using the cursor() # methodcursor = conn.cursor() # delete all details from account tablesql = ''' DELETE FROM account ''' # Executing the querycursor.execute(sql) # Commit your changes in the databaseconn.commit() # Closing the connectionconn.close() |
Output:
Example 2: Using where clause
Where clause is used as a condition statement in SQL, it is used to filter records.
Syntax: DELETE FROM table_name FROM WHERE condition
Code:
Python3
# importing psycopg2import psycopg2 conn=psycopg2.connect( database="geeks", user="postgres", password="password", host="localhost", port="5432") # Creating a cursor object using the cursor() # methodcursor = conn.cursor() # delete details of row where id =1 from account # tablesql = ''' DELETE FROM account WHERE id='151' ''' # Executing the querycursor.execute(sql) # Commit your changes in the databaseconn.commit() # Closing the connectionconn.close() |
Output:
