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

Re: [PATCH] COPY .. COMPRESSED

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Christopher Browne <cbbrowne(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PATCH] COPY .. COMPRESSED
Date: 2013-01-15 22:24:37
Message-ID: 20130115222437.GY16126@tamriel.snowman.net (view raw or flat)
Thread:
Lists: pgsql-hackers
* Bruce Momjian (bruce(at)momjian(dot)us) wrote:
> COPY with a file name is super-user-only.  I am unclear how you would
> use STDIN/STDOUT in any meaningful way with binary data produced by
> compression.  I guess you could with libpq.

The patch that I posted provided this:

psql -h myhost -c "COPY mytable FROM STDIN COMPRESSED;" < myfile.gz

With the compressed file being transferred unmolested to the server side
where it was decompressed and processed by the server.

	Thanks,

		Stephen

In response to

pgsql-hackers by date

Next:From: Kohei KaiGaiDate: 2013-01-15 22:28:40
Subject: Re: Review of Row Level Security
Previous:From: Bruce MomjianDate: 2013-01-15 22:22:47
Subject: Re: [PATCH] COPY .. COMPRESSED

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