Skip site navigation (1) Skip section navigation (2)

working with big text fields

From: Alex Ott <ott(at)jet(dot)msk(dot)su>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: working with big text fields
Date: 2004-08-03 05:48:50
Message-ID: ht2zn5c3h6l.fsf@seal.service.jet.msk.su (view raw or flat)
Thread:
Lists: pgsql-interfaces
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

pgsql-interfaces by date

Next:From: Roman LuchyshynDate: 2004-08-04 10:11:19
Subject: Probrem when select data with large objects
Previous:From: Brijesh ShrivastavDate: 2004-08-03 00:29:26
Subject: Re: libpq binary transfer of the numeric data type -

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group