Stephen Frost <sfrost(at)snowman(dot)net> writes:
> Perhaps I'm taking a bit too narrow view of the world, but my thinking
> is OLTP won't want things compressed, as it increases latency of
> requests, while OLAP users are operating with enough data that they'll
> go through the effort to use COPY.
Also, if there are so many people using COPY in their apps, why have we
never seen any submitted patches to extend libpq with functions to
construct/deconstruct COPY data? Surely somebody would have said to
themselves that they shouldn't be responsible for knowing those escaping
rules.
regards, tom lane