From: | Nicklas Avén <nicklas(dot)aven(at)jordogskog(dot)no> |
---|---|
To: | Jov <amutu(at)amutu(dot)com>, David Rysdam <drysdam(at)ll(dot)mit(dot)edu>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: I want the stupidest possible binary export |
Date: | 2014-09-18 15:18:56 |
Message-ID: | r5qedxa7q5kt2qydwxl1sca2.1411053536439@email.android.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I use php and pg_unescape_bytea
http://php.net/manual/en/function.pg-unescape-bytea.php
You also need to set bytea format to escaped in front of your query.
If php can be en option ....
/Nicklas Avén
Skickat från min Samsung Mobil.
<div>-------- Originalmeddelande --------</div><div>Från: Jov <amutu(at)amutu(dot)com> </div><div>Datum:2014-09-18 16:55 (GMT+01:00) </div><div>Till: David Rysdam <drysdam(at)ll(dot)mit(dot)edu>,pgsql-general <pgsql-general(at)postgresql(dot)org> </div><div>Rubrik: Re: [GENERAL] I want the stupidest possible binary export </div><div>
</div>psql can only input/output text string,which can not be binary content。with 9.2,you can encode bytea to base64,save to file,then use shell command to decode the file。
google “amutu.com pg bytea” can get a blog post。
with upcoming 9.4,you can change bytea to large object,then use lo_* psql cmd save it to file。
2014年9月18日 10:09 PM于 "David Rysdam" <drysdam(at)ll(dot)mit(dot)edu>写道:
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?
--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2014-09-18 15:32:21 | Re: Why isn't Java support part of Postgresql core? |
Previous Message | David Rysdam | 2014-09-18 14:58:00 | Re: I want the stupidest possible binary export |