I have 2 tables say table1 with a geometry column geoloc, and table2 with a geometry column geom,. table1.geoloc in general contains table2.geom. I want to pick those rows where the condition is such, and combine the two tables and create a 3 rd table with both the details including the geometry colmns. I want to rename the columns before inserting into 3rd table
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+2- Contributor
- 606 replies
Hi @ravis91,
It doesn't look like the writer supports handling multiple geometry columns similar to the way the Oracle writer does. However, you should still be able to get this done using two writers: https://knowledge.safe.com/articles/960/template-write-multiple-geometry-types-to-an-exist.html. This could also be done with FeatureWriters if you prefer to keep it all in the same stream (this will also make it easier to control which happens first (insert/update).
Since this is closely related, I'd encourage you to upvote this idea: https://knowledge.safe.com/idea/30260/postgis-reader-should-handle-multiple-geometry-col.html