Day 5: Updating and Deleting Data

In Day 5 of our PostgreSQL learning series, we’ll delve into updating and deleting data from tables in PostgreSQL. We’ll cover these operations in detail with examples to illustrate their usage effectively.

Updating Data

To update existing data in a PostgreSQL table, you can use the UPDATE SQL command. Here’s how it works:

1. Connect to your PostgreSQL database where the table exists using the psql command-line tool.
2. Once connected, execute the following SQL command to update data in the table:

UPDATE tablename SET column1 = value1, column2 = value2, ... WHERE condition;

Replace tablename with the name of the table you want to update. Set the columns to be updated along with their new values. Specify the condition to identify the rows to be updated.

Example:

Let’s update the email address of a customer named ‘John Doe’ in the customers table:

UPDATE customers SET email = 'johndoe@example.com' WHERE name = 'John Doe';

This command will update the email address to ‘johndoe@example.com‘ for the customer named ‘John Doe’.

Deleting Data

To delete data from a PostgreSQL table, you can use the DELETE FROM SQL command. Here’s how to do it:

1. Connect to your PostgreSQL database where the table exists using the psql command-line tool.
2. Once connected, execute the following SQL command to delete data from the table:

DELETE FROM tablename WHERE condition;

Replace tablename with the name of the table you want to delete data from. Specify the condition to identify the rows to be deleted.

Example:

Let’s delete a customer record with the email address ‘johndoe@example.com‘ from the customers table:

DELETE FROM customers WHERE email = 'johndoe@example.com';

This command will delete the customer record with the specified email address from the customers table.

Summary:

• Use the UPDATE command to modify existing data in a table.
• Use the DELETE FROM command to remove data from a table.

Updating and deleting data are crucial operations in database management, allowing you to maintain the accuracy and integrity of your data. Tomorrow, we’ll explore more advanced SQL queries in PostgreSQL. Stay tuned for more PostgreSQL learning!