pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alex Ott <ott@jet.msk.su>
To: pgsql-interfaces@postgresql.org
Subject: working with big text fields
Date: Tue, 03 Aug 2004 09:48:50 +0400
Message-ID: <ht2zn5c3h6l.fsf@seal.service.jet.msk.su> (raw)

Hello all

I need to work with text field of big size - i want to index different
documents with tsearch2 and store their text parts in postgresql. 

Is exists interface, that allow me working with text field as with blob? Or
i must use ordinary insert/update commands for insert large portions of
documents? 

In oracle we heavy use clob field for this task, but in pgsql no such
interface, only ordinary insert/update commands.

-- 
With best wishes, Alex Ott
Jet Infosystems,       http://www.jetinfosoft.ru/
                       +7 (095) 411 76 01



Message-ID: <ht2zn5c3h6l.fsf@seal.service.jet.msk.su>
Permalink:  ../ht2zn5c3h6l.fsf@seal.service.jet.msk.su/
Also on:    postgresql.org/message-id/ht2zn5c3h6l.fsf@seal.service.jet.msk.su

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: ott@jet.msk.su
  Subject: Re: working with big text fields
  In-Reply-To: <ht2zn5c3h6l.fsf@seal.service.jet.msk.su>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox