I want the stupidest possible binary export

From: David Rysdam <drysdam(at)ll(dot)mit(dot)edu>
To: <pgsql-general(at)postgresql(dot)org>
Subject: I want the stupidest possible binary export
Date: 2014-09-18 14:06:35
Message-ID: 87oaudrpjo.fsf@loud.ll.mit.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've got a some tables with bytea fields that I want to export only the
binary data to files. (Each field has a gzipped data file.)

I really want to avoid adding overhead to my project by writing a
special program to do this, so I'm trying to do it from psql. Omitting
the obvious switches for username, etc, here's what I'm doing:

psql -t -c "\copy (select mybinaryfield from mytable where key = 1) to
'file'"

That works, but I get escaped bytes. I want actual binary directly out
of the DB. Another option might be:

psql -t -c "\copy (select mybinaryfield from mytable where key = 1) to
'file'" with format binary

However, there are two problems. First, I get an syntax error "at or
near 'format'". (Running 9.2 client and server.) And second, I suspect
that'll be some "proprietary" PG format, not the actual bytes from just
my field.

What option am I missing?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Szymon Guz 2014-09-18 14:21:55 Re: I want the stupidest possible binary export
Previous Message Adrian Klaver 2014-09-18 13:53:25 Re: strange problem with not existing roles