Conditions in PostgreSQL are generally used with CRUD operations to retrieve more specific results. They are usually used with the WHERE clause. Below is the list of conditions facilitated by the PostgreSQL database.
| CONDITION | USES |
| AND | When 2 or more conditions to be met. |
| OR | When any one of the conditions are met. |
| AND & OR | When AND & OR both conditions are met. |
| LIKE | Simple pattern matching (wildcards) in a where clause. |
| IN | As an alternative to multiple OR conditions. |
| NOT IN | To negate the IN conditions. |
| NOT | To negate a condition. |
| BETWEEN | To retrieve within a range (inclusive). |