Skip site navigation (1) Skip section navigation (2)

[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 (view raw or flat)
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

Responses

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group