working with big text fields - Mailing list pgsql-interfaces

From Alex Ott
Subject working with big text fields
Date
Msg-id ht2zn5c3h6l.fsf@seal.service.jet.msk.su
Whole thread Raw
List 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:

Previous
From: Brijesh Shrivastav
Date:
Subject: Re: libpq binary transfer of the numeric data type -
Next
From: Mark Richardson
Date:
Subject: Re: DataType OID for PQexecParams-call in libpq