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.
@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.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.