There seems to be only 2 posts on here about writing to PostgreSQL bytea, and in both cases, @NatalieAtSafe has said there's a known performance issue. How about for reading? Can FME read a table column in this format? If so, how do you do that? (The data I have stored is a dwg file.)
Solved
Reading PostgreSQL bytea
+1Best answer by markatsafe
@lottegis The PostGIS and PostGreSQL reader support bytea (byte array) data types. If you have a DWG file in the bytea field than you should be able to save it to a file using the AttributeFileWriter transformer.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
@lottegis The PostGIS and PostGreSQL reader support bytea (byte array) data types. If you have a DWG file in the bytea field than you should be able to save it to a file using the AttributeFileWriter transformer.