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
+2
- Contributor
- 606 replies
-
7 July 2020
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
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.