On Mon, Oct 10, 2011 at 9:26 AM, Albe Laurenz <laurenz.albe@xxxxxxxxxx> wrote: > 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. A user defined function, or a binary wire format speaking client side extractor in C/libpq. The basic rule of thumb for me regarding C inside the server is 'only when no other reasonable solution exists'. merlin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
