PostgreSQL WHERE

Filter rows

The WHERE clause keeps only rows for which its condition is true.

SELECT * FROM products
WHERE year = 2025;

Combine conditions with AND, OR, and NOT. Use IS NULL to test for missing values.