Skip to main content
  • EN

When I run the statement 'select st_srid(geom) as epsg from my.table' on the psql command prompt, it correctly returns 31468

 

When I do the same in the SQLExecutor transformer, in returns 0.

Doing the same exercise with 'select count(*) as my_counter', the results are identical.

What is wrong here? The docs?

 

Hi @dollargis, does the query work for other tables?

 

Hi @dollargis,

Both the SQLCreator and SQLExecutor seem to work for me in FME 2018.

What version of FME are you using?

Sorry, my fault - I got confused with the huge number of tables and selected one for the test which indeed had no projection set

Reply


Community Stats

30,108
Posts
114,294
Replies
37,743
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.