X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 52077D1B1FD for ; Tue, 3 Aug 2004 02:49:27 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 01176-06 for ; Tue, 3 Aug 2004 05:49:19 +0000 (GMT) Received: from mx.jet.msk.su (mx.jet.msk.su [62.117.74.155]) by svr1.postgresql.org (Postfix) with ESMTP id 2DB38D1B1DF for ; Tue, 3 Aug 2004 02:49:14 -0300 (ADT) Received: from host1.internal.jet.msk.su ([193.124.4.1] helo=tiger.jet.su) by mx.jet.msk.su with esmtp (Exim 4.34) id 1BrsAC-0004N3-GJ for pgsql-interfaces@postgresql.org; Tue, 03 Aug 2004 09:48:40 +0400 Received: from [192.168.10.173] (helo=seal.service.jet.msk.su.jet.msk.su) by tiger.jet.su with esmtp (Exim 4.33) id 1BrsAW-0007Fd-N2 for pgsql-interfaces@postgresql.org; Tue, 03 Aug 2004 09:49:00 +0400 To: pgsql-interfaces@postgresql.org Subject: working with big text fields From: Alex Ott Organization: Jet Infosystems Date: Tue, 03 Aug 2004 09:48:50 +0400 Message-ID: User-Agent: Gnus/5.110003 (No Gnus v0.3) Emacs/21.3.50 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/4 X-Sequence-Number: 5052 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