PostgreSQL WHERE - Filter Data

Filter Records

The WHERE clause is used to filter records.

It is used to extract only those records that fulfill a specified condition.

If we want to return only the records where city is London, we can specify that in the WHERE clause:

Text Fields vs. Numeric Fields

PostgreSQL requires quotes around text values.

However, numeric fields should not be enclosed in quotes:

Greater than

Use the > operator to return all records where customer_id is greater than 80:

SELECT * FROM customers
;