On Mon, Oct 10, 2011 at 9:26 AM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> wrote:
> I wrote:
> [fanlijing wants to write bytea to file]
>> A simple
>> COPY (SELECT byteacol WROM mytab WHERE ...) TO 'filename' (FORMAT
>> should do the trick.
> 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'.
In response to
pgsql-admin by date
|Next:||From: Akash Kodibail||Date: 2011-10-10 15:54:57|
|Subject: Postgres Server crashed|
|Previous:||From: Albe Laurenz||Date: 2011-10-10 14:26:26|
|Subject: Re: [GENERAL] how to save a bytea value into a file?|
pgsql-general by date
|Next:||From: Mark Keisler||Date: 2011-10-10 16:05:17|
|Subject: streaming replication|
|Previous:||From: John R Pierce||Date: 2011-10-10 15:29:49|
|Subject: Re: Postgres 9.01, Amazon EC2/EBS, XFS, JDBC and lost connections|