Just a random query but this requires postgis to be installed. And don't forget to install it on standby's as well(if you're using replication)
select st_distance(st_makepoint(42.636002, -78.042527)::geography, st_makepoint( 42.582562, -77.941819 )::geography);
Happy to help :)
Prince Pathria
Systems Architect Intern
Evive
+91 9478670472
goevive.com
On Thu, Sep 20, 2018 at 3:11 PM Pierre Ochsenbein <pierreochsenbein@xxxxxxxxx> wrote:
Hey Guy'sI Have install my PostGIS extension on my instance and I would like to try if it's works fine.Any idea?Thx