HowToGIS

Just a test drive for postgis:

SELECT esn_id from PSAP as "geospatial-data" WHERE ST_Contains("geospatial-data".geom,ST_GeomFromText('POINT(-90.56210 38.60369)'));

Yields:

"E29189002"

Total query runtime: 15 ms.

1 row retrieved.

Would you like to know more?...

Summary only...https://howtogis.blogspot.com/2015/05/just-test-drive-for-postgis-select.html