Question

PostGIS "Create Generic Spatial Columns" setting

  • 21 August 2013
  • 0 replies
  • 1 view

Badge
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

0 replies

Be the first to reply!

Reply