Question

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 ?

  • 23 February 2023
  • 2 replies
  • 3 views

Badge +1
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 ?

2 replies

Badge +10

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

Badge +1

Yep, that seems to be it, thanks

Reply