Received: from mail_exchange.westcountrypublications.co.uk ([195.171.163.135]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9IDgVP46911 for ; Thu, 18 Oct 2001 09:42:31 -0400 (EDT) (envelope-from SHenshall@westcountrypublications.co.uk) Received: by MAIL_EXCHANGE with Internet Mail Service (5.5.2650.21) id <475AG89Y>; Thu, 18 Oct 2001 14:40:17 +0100 Message-ID: From: "Henshall, Stuart - WCP" To: "'Frank Zhu'" , pgsql-sql@postgresql.org Subject: Re: Text/Image, JSP tomcat. How can I operate the text and image Date: Thu, 18 Oct 2001 14:40:15 +0100 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-Type: text/plain X-Archive-Number: 200110/251 X-Sequence-Number: 5206 Have a look at lo_import and lo_export. Can handle chunks at a time Also bytea type. You have to handle complete items with this. Although it'd need some formating. I believe zeros go to \000, ' to \' and \ to \\ as a bare minimum, but am not at all sure on that. - Stuart > -----Original Message----- > From: Frank Zhu [SMTP:frankzyz@etang.com] > Sent: Tuesday, October 16, 2001 4:42 AM > To: pgsql-sql@postgresql.org > Subject: Text/Image, JSP tomcat. How can I operate the text and image > type field in Postgresql? only in java/jsp > > I want to store a long article in the Postgresql in Linux, how can I put > the > content into it and redraw it back to show? urgent. Thanks. > I use JSP. > I note that all database systems are very dull in BLOB. Why? > > Frank Zhu. > >