[PATCH] COPY .. COMPRESSED

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: [PATCH] COPY .. COMPRESSED
Date: 2013-01-14 02:16:44
Message-ID: 20130114021644.GG16126@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Greetings,

Attached is a patch to add a 'COMPRESSED' option to COPY which will
cause COPY to expect a gzip'd file on input and which will output a
gzip'd file on output. Included is support for backend COPY, psql's
\copy, regression tests for both, and documentation.

On top of this I plan to submit a trivial patch to add support for
this to file_fdw, allowing creation of FDW tables which operate
directly on compressed files (including CSVs, which is what I need
this patch for).

I've also begun working on a patch to allow this capability to be used
through pg_dump/pg_restore which would reduce the bandwidth used
between the client and the server for backups and restores. Ideally,
one would also be able to use custom format dumps, with compression,
even if the client-side pg_dump/pg_restore wasn't compiled with zlib
support.

Thanks,

Stephen

Attachment Content-Type Size
copy_compressed.patch text/x-diff 31.6 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2013-01-14 03:27:12 Re: Possible PANIC in PostPrepare_Locks
Previous Message Noah Misch 2013-01-14 00:01:07 Re: pgcrypto seeding problem when ssl=on