Re: decoding BLOB's

[John R Pierce <pierce@xxxxxxxxxxxx>]

On 2/22/2016 11:23 AM, Joshua D. Drake wrote:

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?

http://www.postgresql.org/docs/9.3/static/functions-binarystring.html

Substring might do it for you.

won't doing it in SQL still result in a BYTEA result which will be wrapped when dumped via COPY ?

instead, I think this needs to be done externally to sql, like by piping the resulting file through something like ...

tail -c +25 infile.dat | head -c -2 > outfile.dat

or doing something in perl or whatever.

-- 
john r pierce, recycling bits in santa cruz