Skip to main content
Question

PostGreSQL: non-spatial data reader


Hello,

I have FME 2018.1 and PostgreSQL 9.4.

I try to create a reader with non spatial date so I could join them with spatial data but it seems FME can't reader the features in the non-spatial table.

I tried to open it in the Inspector but it doesn't work too:

 

Opening POSTGRES reader for dataset 'cadastre_2019'

PostGIS client encoding: 'UTF8'

PostgreSQL 9.4.0, compiled by Visual C++ build 1800, 64-bit

Successfully closed POSTGRES database reader

Successfully closed POSTGRES database reader

Merged 1 schema features read from 1 datasets into 1 resulting feature types

Saving spatial index into file 'C:\\Users\\J\\AppData\\Local\\Temp\\FFS_1579770320565_8204_DATA.fsi'

Finished saving spatial index into file 'C:\\Users\\J\\AppData\\Local\\Temp\\FFS_1579770320565_8204_DATA.fsi'

Removing dataset 'cadastre 2019 [POSTGRES]' from View 1

Successfully closed POSTGRES database reader

The dataset 'cadastre<space>2019' was closed successfully

The 'POSTGRES' reader was destroyed successfully

 

Is anyone had an idea about that?

 

Thanks in advance!

2 replies

oscard
Influencer
Forum|alt.badge.img+21
  • Influencer
  • January 23, 2020

Are you using PostGres o PostGis reader? You should use the PostGres one for non-spatial data


Forum|alt.badge.img+2
  • January 23, 2020

@jennpe It looks like that table is empty. All signs are that FME found the "cadastre 2019" but didn't read any records.

The message: Removing dataset 'cadastre 2019 [POSTGRES]' from View 1 usually means the View was removed because no data was found

In FME Workbench try using the SQLCreator to read the table with a SELECT clause, or check your table in PGAdmin or equivalent.


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