From: | Jov <amutu(at)amutu(dot)com> |
---|---|
To: | 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 14:55:33 |
Message-ID: | CADyrUxM21sq2CThndK6b15TOjPT7yc0rmo8VDGzZ4s02JHA63A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 | David Rysdam | 2014-09-18 14:56:10 | Re: I want the stupidest possible binary export |
Previous Message | Adrian Klaver | 2014-09-18 14:24:05 | Re: I want the stupidest possible binary export |