PostGIS: Can´t preview geometry when in different schema than public - why?
Geographic Information Systems Asked by Emanuelv on January 4, 2021
So I’m trying to wrap my head around PostGIS and how to get it working correctly in a schema other than ‘public’.
I followed this tutorial, and transfered PostGIS to my own schema, postgis_test. I used the PostGIS shapefile importer and imported my shapefile. Everything looks good (see screenshot of the geometry column), but the option to preview the geometry (the ‘Eye’-icon) from the table is gone – why could that be?
One Answer
PostGIS should stay in the public schema (then everyone can see it) while your data can live in individual schemas. This allows you to upgrade PostGIS without needing to backup, drop and restore the data tables since only public needs to be changed.
Answered by Ian Turton on January 4, 2021
Add your own answers!
Ask a Question
Get help from others!
Recent Answers
- Joshua Engel on Why fry rice before boiling?
- Peter Machado on Why fry rice before boiling?
- Jon Church on Why fry rice before boiling?
- Lex on Does Google Analytics track 404 page responses as valid page views?
- haakon.io on Why fry rice before boiling?
Recent Questions
- How can I transform graph image into a tikzpicture LaTeX code?
- How Do I Get The Ifruit App Off Of Gta 5 / Grand Theft Auto 5
- Iv’e designed a space elevator using a series of lasers. do you know anybody i could submit the designs too that could manufacture the concept and put it to use
- Need help finding a book. Female OP protagonist, magic
- Why is the WWF pending games (“Your turn”) area replaced w/ a column of “Bonus & Reward”gift boxes?