Multiple-row text - Mailing list pgsql-general

From Nicholas Negulescu
Subject Multiple-row text
Date
Msg-id 200002191513.HAA01493@www.geocrawler.com
Whole thread Raw
Responses Re: [GENERAL] Multiple-row text  (Lincoln Yeoh <lylyeoh@mecomb.com>)
List pgsql-general
This message was sent from Geocrawler.com by "Nicholas Negulescu" <negulen@eou.edu>
Be sure to reply to that address.

Hi, I'm looking for a solution to the 8k limit on
text in Postgres. I want the text to be
searchable, so a large object is out. Does
anybody have a method to split text larger than
8k and insert it into a multiple-row entry...

so in the db i'd have:

ID| piece id | text|

where the piece ID is the number of the text
fragment.

Any help (or a url) would be appreciated!

Geocrawler.com - The Knowledge Archive

pgsql-general by date:

Previous
From: Howie
Date:
Subject: Re: [GENERAL] Deleting large objects sans index
Next
From: Tom
Date:
Subject: Backend terminated abnormally error ?