Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Data
  • If I use a PostGIS Reader, to inspector, on a table, it shows the geometry. If I use a SQLCreator using POSTGIS format, doing a select * from same table, it shows fme no geom, is that normal for a SQL to not show the geometry ?
If I use a PostGIS Reader, to inspector, on a table, it shows the geometry. If I use a SQLCreator using POSTGIS format, doing a select * from same table, it shows fme no geom, is that normal for a SQL to not show the geometry ?

You may need to explicitly specify the geometry column in the sql statement. I've found in the past that if there are multiple geometry columns or if the geometry column is named in a slightly non standard way

Yep, that seems to be it, thanks

Reply


Community Stats

30,126
Posts
114,354
Replies
37,759
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.