which essentially is: how to import contents from a file without any particular interpretation of any character?
With the patch discussed in this thread, a user can do \copy table(textcol) from /path/to/file (format raw)
What is needed to solve this specific use-case is a way to specify "QUOTE NONE" instead of the default for whatever format is being hijacked:
COPY file_content FROM '/tmp/textfile.txt' WITH (FORMAT csv, QUOTE E'<unprintable character that should never appear in the data>');
becomes
COPY file_content FROM '/tmp/textfile.txt' WITH (FORMAT csv, QUOTE NONE);
Or maybe: "WITH (FORMAT single_column)"
Though maybe that doesn't extend well to unencoded binary data...which seems like it can be considered a separate problem from reliably importing an entire file into a single row+column in a table.
