On 2/24/17 7:44 AM, Kenneth Marshall wrote:
> Like David suggests,
> if you want compact, run it through lz4/gzip/lzop...for a much better size
> return.
Speaking of which; any bytea where you care about this is likely to live
in an already compressed state in toast. ISTM it would be valuable if we
had a way to just spit out the raw compressed data (or a text-safe
version of that), at least for COPY's purposes...
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)