PostgreSQL WHERE

PostgreSQL Notes · Coding Now Tech Institute1 min readSource

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:

Example

SELECT * FROM customers
WHERE
city = 'London';

Text Fields vs. Numeric Fields

PostgreSQL requires quotes around text values.

However, numeric fields should not be enclosed in quotes:

Example

SELECT * FROM customers
WHERE
customer_id = 19;

Note: Quotes around numeric fields will not fail, but it is good practice to always write numeric values without quotes.

Greater than

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

Example

SELECT * FROM customers
WHERE
customer_id > 80;

Note: Quotes around numeric fields will not fail, but it is good practice to always write numeric values without quotes.

PreviousPostgreSQL SELECT DISTINCT Next PostgreSQL ORDER BY

Want to go beyond the notes?

Join Coding Now Tech Institute's PostgreSQL course — live mentorship, real projects, and 100% placement support.

Enroll Now — Free Demo Available

PostgreSQL WHERE – FAQs

Quick answers about learning PostgreSQL WHERE in PostgreSQL.

What does this PostgreSQL WHERE note cover?

This free note from Coding Now Tech Institute explains PostgreSQL WHERE in PostgreSQL — concept, syntax and worked code examples you can copy, run and revise before interviews.

Is this PostgreSQL WHERE tutorial free?

Yes. Every PostgreSQL topic on Coding Now Tech Institute, including PostgreSQL WHERE, is 100% free with no signup required.

How long does it take to learn PostgreSQL WHERE?

With focused practice, most students grasp PostgreSQL WHERE in 1–3 days from these notes; pairing it with Coding Now Tech Institute's mentor-led course takes you to job-ready depth faster.

Where can I practise PostgreSQL WHERE after reading?

Use the code examples in this note, then ask doubts for free on the Coding Now Tech Institute Community (/community) — expert instructors answer within 24 hours.