Can I use R to transfer non R files to a data base?

[iain]

This discussion on loading binary files into postrgres might be of interest

Storing and retrieving files/images in a database from Shiny app

Awesome reprex!! Thank you!! That made my life so much easier And now we get a functional example!! (I think). I have to admit my testing is pretty minimal. I think we're super close though! This is exciting stuff! You were trying to write a vector to the database, and RPostgres was complaining. Postgres wants a string representation of the hex (prefixed with \x), which I just did with a little paste(..., collapse = ""). I'm sure there are other ways to marshal all of this w/ string manipulation, hex / binary conversion, etc. It looks like it's working though!! library(RPostgres) library(hexView) library(readr) con <- dbConnect(RPostgres::Postgres(),host="localhost", …