Andrew Dunstan wrote: > If someone can make a good case that this is going to be of > general use I'll happily go along, but I haven't seen one so far.
About COPY FROM with a raw format, for instance just yesterday there was this user question on stackoverflow: http://stackoverflow.com/questions/36317237 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) or the equivalent COPY. If it's a binary column, that works just the same. Without this, it's not obvious at all how this result can be achieved without resorting to external preprocessing, and assuming the availability of such preprocessing tools in the environment. Notwithstanding the fact that the solution proposed on SO (doubling backslashes with sed) doesn't even work if the file contains tabs, as they would be interpreted as field separators, even if the copy target has only one column. You can change the delimiter with COPY but AFAIK you can't tell that there is none. Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
