| From: | CS DBA <cs_dba(at)consistentstate(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | decoding BLOB's |
| Date: | 2016-02-22 19:08:09 |
| Message-ID: | 56CB5C99.6030803@consistentstate.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi All;
we've found a post about dumping blobs:
/
/
/I wrote: [fanlijing wants to write bytea to file] > A simple > COPY
(SELECT byteacol WROM mytab WHERE ...) TO 'filename' (FORMAT binary) >
should do the trick. Corrections: a) "binary" must be surrounded by
single quotes. b) *that won't dump just the binary data - you would have
to remove the first 25 bytes and the last 2 bytes...* So maybe using the
functions I mentioned would be the best way after all. You could also
write your own user defined function in C. /
Can someone point me in the right direction per how I would remove the
first 25 bytes and the last 2 bytes from a bytea column?
Thanks in advance
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2016-02-22 19:23:31 | Re: decoding BLOB's |
| Previous Message | Seamus Abshere | 2016-02-22 18:14:56 | Re: Why does query planner choose slower BitmapAnd ? |