topic Re: Import binary files into Postgres Database in Talend Studio

Import binary files into Postgres Database

_AnonymousUser — Sat, 16 Nov 2024 12:51:44 GMT

I need to migrate binary files (pdfs, txt,...) from disk into a Postgres Database (bytea). How does this work, is it even possible?

Re: Import binary files into Postgres Database

Anonymous — Wed, 15 Jun 2011 15:31:12 GMT

You load the file into the database using lo_import(), and retrieve it from the database using lo_export().
in the advanced settings of your postgres output, under additional columns, replace your blob column with lo_import(?)
the data value for this column should be the file name you want to insert to the blob.

Re: Import binary files into Postgres Database

_AnonymousUser — Thu, 16 Jun 2011 10:11:14 GMT

as I know lo_import() is only for oid
for bytea you need a JDBC PreparedStatement, right?
I thought there is a easier way in talend to do this (in combination with tmap)

Re: Import binary files into Postgres Database

Anonymous — Thu, 16 Jun 2011 10:39:32 GMT

Hi
You can find a similar request in topic:
https://community.talend.com/t5/Design-and-Development/resolved-File-into-BLOB/td-p/67476
Best regards
Shong