Skip to main content

When I add a Reader in FME Workbench 2019.2, I cannot connect to a PostgreSQL FDW (Foreign Data Wrapper). I can select (check) the FDW schema, but I cannot open the list of tables. (The FDW is in a PostgreSQL table and I can access the PostgreSQL schemas just fine.)

 

DataGrip can open the FDW schema and its tables just fine using the exact same connection (host, database, username, and password).

 

There seems to be almost nothing in Google about FME and PostgreSQL FDW. Is it impossible, or is it just too obvious for me to figure out?

Yes, it was too obvious for me to figure out.

 

I left the schema box unchecked and included the schema name in the table name. It's working now.


Yes, it was too obvious for me to figure out.

 

I left the schema box unchecked and included the schema name in the table name. It's working now.

Curious thing though: if I so much as touch the Reader's User Attributes list, or change "Attributes to Read", the geometry field disappears from the Attribute list and will only come back by using Undo.


Reply