Using PostGIS & PostgreSQL (Amazon RDS instance), I need to create a (quite large) table with points (just x, y coordinates) Then what I need to do is very simple point-in-polygon queries. Points and polygons are in 2D space (not geography types).
I actually managed to do this with Amazon Athena with this simple query:
SELECT ST_WITHIN(ST_POINT(x, y), ST_POLYGON('polygon((1 1, 11 44, 44 44, 44 11))')) FROM "my_table"
How it would be possible to have this kind of query working at PostgreSQL?