How to write workspace to convert Oracle blob (jpeg image) to PostGIS bytea

Question

I have a non-spatial Oracle table fifteen attribute columns, two of which columns store images.

One column is called “image” and the other column is called “thumbnail”

Both store images in jpeg format.

All of the jpegs are less than 1MB in file size

I want to write this table to PostGIS

I have constructed a table in PostGIS with the columns “image” and “thumbnail” both defined as bytea

How do I write the workspace that Reads from Oracle and Writes to PostGIS?

I made an attempt, but now FME fails to display the data from the PostGIS table, so there is something wrong.

My version of FME Desktop is

FME(R) 2022.1.3.0 (20220928 - Build 22630 - WIN64)

j.botterill · Answer

Yes, you can write to a PostgreSQL/PostGIS bytea (BLOB) column from FME.Either in the Reader to the oracle format, inspect the exposed attributes you have and check what data type they are? Tip inspect the data and use the Record/Feature Information windowoptional, perhaps not for your use case: You may also want to lookup more about AttributeFileReadertransformer, pointed to the oracle ‘image’ and another to the ‘thumbnail’ reads.AttributeFileWriter is typically used in the opposite direction (writing a blob attribute out to a file).In the PostGIS Writer attribute definition, make sure you select the bytea type

How to write workspace to convert Oracle blob (jpeg image) to PostGIS bytea

1 reply

Community Stats

Community Stats

Sign up

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute