Postgresql + POSTGIS

Question

I'm trying to deploy PostgreSQL + PostGIS for my ruby app. I follow this tutorial, but when I'm typing: CREATE EXTENSION PostGIS the terminal returns,

CREATE EXTENSION postgis;
CREATE : undefined command

my setup:

POSTGRESQL 10.4
Ruby 2.4.3
Rails 5.1.6

Jim Jones · Accepted Answer · 2020-03-06 08:47:57Z

1

Where are you executing CREATE EXTENSION postgis? This command has to be executed in the database via a PostgreSQL client, such as psql or pgAdmin. What you're getting is an error message from your console, which does not know this command.

Try this from your console:

psql -d yourdatabase -c "CREATE EXTENSION postgis"

Check the psql documentation for more details on how to connect to the database.

edited Mar 6, 2020 at 8:47

answered Jul 2, 2018 at 8:53

Jim Jones

19.9k3 gold badges44 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgresql + POSTGIS

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related