Re: PostGIS extension

[Prince Pathria <prince.pathria@xxxxxxxxxxx>]

or use \dx on that db to verify which extensions are enabled on that specific db.

Happy to help :)

Prince Pathria Systems Architect Intern Evive +91 9478670472 goevive.com

On Thu, Sep 20, 2018 at 5:00 PM Prince Pathria <prince.pathria@xxxxxxxxxxx> wrote:

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's

I Have install my PostGIS extension on my instance and I would like to try if it's works fine.

Any idea?

Thx