Skip to main content
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 ?

  • February 23, 2023
  • 2 replies
  • 17 views

mferwerda1111
Participant
Forum|alt.badge.img+2
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

ebygomm
Influencer
Forum|alt.badge.img+39
  • Influencer
  • February 23, 2023

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


mferwerda1111
Participant
Forum|alt.badge.img+2
  • Author
  • Participant
  • February 23, 2023

Yep, that seems to be it, thanks


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings