I'm trying to check whether or not the PostGIS extension is installed, as a PG query. I'm unable to find this info out.


In psql CLI use \dx to display all installed extensions in the current database or with SQL:

select * from pg_extension

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy