fme
I have build a simple workflow in FME 2014 (as shown in the image) to get data from an excel file and store them in a postgres database. For this purpose I use SQL Executor.
I manage to pass all the data to the database but for some reason I can not see in the dialog box where I build the SQL Statement (in the properties of SQL Executor) the geom column which I have in my database table.
Why this happens?
More an additional Comment (with an image) than Answer
Same Oracle Spatial Connection - Same TABLE - but using two TESTERs to define FeatureType
and then write the to visualiser (or Shapefiles)
I believe this page will answer your question: http://blog.safe.com/2011/05/fmeevangelist79/
It sounds like using the 'Joiner' transformer in your workflow will work. The crucial part you mention makes it sound like you don't actually want to merge the two, but rather add a relationship between the table and the shapefile.
Best Answer
It may be because you're using the Postgres format, which FME would class as non-spatial (or tabular). If you used PostGIS instead it might show you the geometry column.
Regardless, I agree with the other poster that the more usual approach would be to use a Writer, rather than trying to pass data through the SQLExecutor. Then geometry is handled automatically.
If you're new to FME, then please do feel free to contact the support team (http://safe.com/support) and ask for their assistance or guidance. Not that I'm against posting on this site, I just figure you might get quicker answers.