Question

Can FME access a PostreSQL FDW?

P

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?

2 replies

P

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.

P

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


Community Stats

28,659
Posts
109,313
Replies
36,529
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.