Re: COPY table_name (single_column) FROM 'unknown.txt' DELIMITER E'\n'

On Thu, 6 May 2021 at 12:02, Joel Jacobson <joel(at)compiler(dot)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.