decoding BLOB's

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

Responses

Browse pgsql-general by date

  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 ?