The post How to insert (file) data into a PostgreSQL bytea column was helpful.
However, when I select these columns, I get the same hex encoded data.
For instance:
> select substring(smallblob,0,64) from longdata where blobi d=1; \xd0cf11e0a1b11ae1000000000000000000000000000000003b000300feff09000600000000000 00000000000010000006a0000000000000000100000670000 (1 row)
How can I SELECT
this data in binary format? CAST' and
CONVERT` do not appear to support a 'binary' option.