PostgreSQL Select

The PostgreSQL SELECT statement is used to query records from a table.

Select syntax

-- select all records from table
SELECT * FROM table_name

-- select specific columns 
SELECT column_1, column_2 FROM table_name

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

Select 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;

SELECT id, name FROM goods;

SELECT id, name FROM goods WHERE id > 3;

SELECT * FROM goods WHERE name LIKE '%Boat%';