Skip to content

Instantly share code, notes, and snippets.

@dsandip

dsandip/create-PostGIS-extension.sql

Last active May 15, 2020 23:26
Show Gist options
  • Save dsandip/a153dbd3907a174c9949c77a2f31e290 to your computer and use it in GitHub Desktop.
Save dsandip/a153dbd3907a174c9949c77a2f31e290 to your computer and use it in GitHub Desktop.
Download ZIP
Commands to create PostGIS extension for Postgres
Raw
create-PostGIS-extension.sql
CREATE EXTENSION postgis;
CREATE EXTENSION postgis_topology;
@sanderhahn
Copy link

The extension postgis_topology is not necessary and doesn't work on Heroku with Postgres v12. So that one can be removed from the instructions and change the word "topology" into "geography" on the blog article :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment