On Thu, 6 May 2021 at 12:02, Joel Jacobson <j...@compiler.org> wrote:
> On Thu, May 6, 2021, at 13:41, Isaac Morland wrote: > > Yes! A significant missing feature is “take this arbitrary bucket of bits > and move it to/from the database from/to this file without modification of > any kind”. There are all sorts of tutorials on the Web about how to almost > do it or fake it or convert to hex or whatever but I’ve never seen a nice > simple explanation of “here is the command:”. > > Of course there is a lot to think about. Coming out of the database, the > query result must be exactly one row containing exactly one column; how do > we handle other database results? Coming into the database, only one data > value can come from a single file; so how do we populate the other columns > of whatever table we copy to? > > If the file is on the server, you can use pg_read_binary_file() for that > purpose. > Yes, sorry, I should have explicitly said “on the client” somewhere up there. Getting files from the DB server into the DB is no problem.
