Skip to main content
Question

PostGIS "Create Generic Spatial Columns" setting


Forum|alt.badge.img
Hello List

 

 

I need to be able to change the setting to create default spatial columns from YES to NO in existing workbenches writing to PostGIS.

 

 

From this question (https://safe.secure.force.com/apex/AnswersQuestionDetail?id=906a0000000ciBiAAI) and Mark's answer:

 

 

Another setting that may help, when you add a new writer look at the properties dialog and there is a setting called "Create Generic Spatial Columns". As long as that is checked the table should be a generic one and not need a geometry type set.

 

 

I have been able to get my (new) workbenches to work the way I want them.  However, I have a number of old workbenches with the option checked.  When I connect my QGIS to PostGIS I see duplicate entries in the layer picker - one for the table with correct geometry and one for the table with unknown geometry.  Can I retrospectively edit my workbench to change this setting?

 

 

Thanks

 

 

Ross

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings