I have an xml file with a BLOB column (Photo) and I need to insert it into a table in Postgree as base64, does anyone know how I can do it. I'm a beginner and I can't do it. Thanks!
I suspect that the blob column will already be in base64. Have you tried reading the XML using a tFileInputXML and loading from there? The tFileInputXML documentation is here...