PostgreSQL Where

PostgreSQL Where

The PostgreSQL WHERE clause is used to return records that meet the conditions in a select.

Where syntax

-- select the records that meet the condition
SELECT * FROM table_name WHERE {condition}

SELECT * FROM view_name WHERE {condition}

SELECT * FROM A, B WHERE A.id=B.id

Where example

Goods table

id good_type name description price insert_date
1 A Car_1 Car 1 description 100 2018-07-21 08:45:57.311809
2 A Car_2 Car 2 description 200 2018-07-21 08:45:57.311809
3 A Car_3 Car 3 description 100 2018-07-21 08:45:57.311809
4 B Boat_4 Boat 4 description 500 2018-07-21 08:45:57.311809
5 B Boat_5 Boat 5 description 300 2018-07-21 08:45:57.311809
6 C Train_1 Train 123 description 800 2018-07-21 08:45:57.311809
SELECT * FROM goods WHERE price = 100;

Result

id good_type name description price insert_date
1 A Car_1 Car 1 description 100 2018-07-21 08:45:57.311809
3 A Car_3 Car 3 description 100 2018-07-21 08:45:57.311809