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
Question
Insert Geometry columns from 2 different but related tables into Postgres Database
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- Safer
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
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.