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
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.