Postgis installation: type “geometry” does not exist

by

I had the same problem, but it was fixed by running following code

CREATE EXTENSION postgis;

In detail,

  1. open pgAdmin
  2. select (click) your database
  3. click “SQL” icon on the bar
  4. run “CREATE EXTENSION postgis;” code

More Related Contents:

  1. Buffers (Circle) in PostGIS
  2. Multicolumn index on 3 fields with heterogenous data types
  3. What is PostgreSQL equivalent to autoincrement?
  4. How do I specify a password to ‘psql’ non-interactively?
  5. Use multiple conflict_target in ON CONFLICT clause
  6. PostgreSQL -must appear in the GROUP BY clause or be used in an aggregate function
  7. How to find table creation time?
  8. Go and IN clause in Postgres
  9. Where does PostgreSQL store the database?
  10. How to add “on delete cascade” constraints?
  11. Is there a way to disable function overloading in Postgres
  12. Grant all on a specific schema in the db to a group role in PostgreSQL
  13. Can I make a plpgsql function return an integer without using a variable?
  14. Migrate database from Postgres to MySQL [closed]
  15. How can I start PostgreSQL on Windows?
  16. PostgreSQL – max number of parameters in “IN” clause?
  17. SQLAlchemy, Psycopg2 and Postgresql COPY
  18. How to find out if an upsert was an update with PostgreSQL 9.5+ UPSERT?
  19. Why can I create a table with PRIMARY KEY on a nullable column?
  20. Oracle SQL Developer and PostgreSQL
  21. PostgreSQL array of elements that each are a foreign key
  22. How to reset sequence in postgres and fill id column with new data?
  23. Differentiate inserted and updated rows in UPSERT using system columns
  24. Postgres ERROR: could not open file for reading: Permission denied
  25. PostgreSQL – disabling constraints
  26. Heroku database restore issue
  27. user postgres launches process that takes all CPUs 100% usage
  28. Postgres table column name restrictions?
  29. How do I get min, median and max from my query in postgresql?
  30. Error when pushing data to Heroku: time zone displacement out of range

Leave a Comment