PostgreSQL — Update

Basic Update

UPDATE users SET name = 'Jane' WHERE id = 1;

Multiple Columns

UPDATE users 
SET name = 'Jane', email = 'jane@example.com' 
WHERE id = 1;

Update All Rows

UPDATE users SET active = true;

With Subquery

UPDATE users 
SET country = 'USA' 
WHERE id IN (SELECT id FROM orders WHERE total > 100);

Returning

UPDATE users 
SET name = 'Jane' 
WHERE id = 1 
RETURNING *;

Using Expression

UPDATE products 
SET price = price * 1.1 
WHERE category = 'electronics';

Conditional Update

UPDATE users 
SET status = CASE 
    WHEN age > 18 THEN 'adult'
    ELSE 'minor'
END;

Mini Practice

1. Update single row
2. Update multiple columns
3. Use expressions
4. Return updated data

Up Next

Continue with Delete — deleting data.