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: | Raw Message | Whole Thread | 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 ? |