Search

Viewing PostGIS data with an FME Connection in ArcGIS

Liz Sanderson
Liz Sanderson
  • Updated

Symptom

When previewing a PostGIS table after creating an FME Connection to it in ArcGIS the following symptoms may occur:

- a message "The current selection be displayed as a table" appears
- an empty table appears
- an error about a numeric index appears

Cause

To see the table in ArcGIS you must have a unique integer field in your table when writing to PostGIS.
 

Resolution

Using SQL Command: Using SQL Statement create a spatial index on the table. See troubleshooting documentation for the commands.
In FME Desktop: Use the "int4" type on the destination schema with "PRIKEY" set for the Index to achieve this. A Counter can be used to create unique values if they do not already exist on your features.

Was this article helpful?

We're sorry to hear that.

Please tell us why.

As of January 14th, 2026, comments on knowledge base articles have been closed. To make sure questions don’t get missed and to enable more community support, we’ve moved discussions to the FME Community. If you have a question or a comment about this article, please create a new post or create a support ticket.