Re: [PATCH] COPY .. COMPRESSED

On 01/15/2013 06:22 PM, Tom Lane wrote:
> 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.

There are perfectly good libraries in Perl and other languages for
constructing/deconstructing CSV data. If we didn't have CSV
import/export I suspect we would have heard lots more howls by now.

cheers

andrew