How to determine whether a point belongs to a polygon in postgresql?

Question

PostgreSQL

Good afternoon. A difficulty arose. Help decide. I have a table (point) in which the coordinates of points (geometry) are stored. There is also a second table (borough) that stores the coordinates of the polygons (geom). The next question is: Calculate for each polygon, the number of points lying in it. I know to use one of the following ST_Within or ST_Contains functions. But unfortunately I can not figure it out ((
Thanks in advance.

Answer 1

Probably something like this: sqlfiddle.com/#!15/415f5/9

Answer 2

SELECT id, 
       (SELECT COUNT(*) FROM point AS b WHERE ST_Within(points.geometry, borough.geometry)) AS count,
       name
  FROM borough