Why I still can not use Postgis function after install the Postgis extension

Question

Well as clear as the title, my college set up the database and said that already add Postgis extension to the database.

However, I still can not use the function of Postgis

ERROR: function routing.st_distancesphere(unknown, text) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 47

Answer 1

You can run the following to confirm if you have postgis installed

SELECT PostGIS_version();

If not installed then you can install it with

CREATE EXTENSION postgis;