I am loading a set of shapefiles into a PostGIS database using a shapefile reader and a PostGIS writer. If I accept the default workbench created by FME the data gets written to the public schema. Where/how can I set the schema in the writer that I actually want the data written to? Probably a simple solution...
FME Desktop 2012 sp3 and PostgreSQL 9.1 with PostGIS 2.0
Thanks
Best answer by brendan
http://fmepedia.safe.com/articles/Error_Unexpected_Behavior/In-the-Postgis-Postgres-reader-tables-from-a-different-schema-don-t-show-up
I have used it before and it worked.
Hi,
Supplementing this answer with FME 2015 guidelines:
To write data in a different schema within a PostgreSQL or PostGIS database you need to type the schema name within the the PostgreSQL or the PostGIS database writer under the "General" tab and within the "Table Qualifier" form.
+22Just had this question myself and this is how I fixed this: just add the schema<dot> in front of your table name, which can be parameterized or filled with attribute value.
schema.mytable
