how to save a bytea value into a file?

From: "fanlijing" <fanlijing(at)cn(dot)fujitsu(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: how to save a bytea value into a file?
Date: 2011-10-09 08:00:53
Message-ID: 038517CEB6DE43BD8422D7947B6BE8D8@fanlijing
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Hello PostgreSQL members：

I'm a user of PostgreSQL. Now I have a question when using it.
When I want to save a bytea value into a file, what should I do？
Is there any function dealing with that in PostgreSQL? (like lo_export() to
deal with the large-object) (# I didn't find any....)

Sorry for interrupting you.
Thanks anyway.

Best regards
Fan Lijing
2011-10-09

Regards
Fan Lijing
--------------------------------------------------------
Oversea Business Department,
Jiangsu Fujitsu Telecommunications Technology Co.,Ltd.(JFTT) No.118, Dengwei
Rd.,Suzhou, P.R. China
Postcode: 215011
PHONE #86-512-68250097-8506 / COINS : 7991-8506
FAX #86-512-68250045 / COINS FAX :
Mail #fanlijing(at)cn(dot)fujitsu(dot)com
--------------------------------------------------------

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Lukasz Brodziak 2011-10-09 08:49:28 Re: DB corruption.
Previous Message Jesper Krogh 2011-10-09 06:40:08 DB corruption.

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2011-10-09 10:39:03 Re: [9.2devel] why it doesn't do index scan only?
Previous Message skmanji 2011-10-09 07:39:16 Re: How to restore a SQL-ASCII encoded database to a new UTF-8 db?