Multiple-row text

From: "Nicholas Negulescu" <archiver(at)db(dot)geocrawler(dot)com>
To: pgsql-general(at)hub(dot)org
Subject: Multiple-row text
Date: 2000-02-19 15:13:35
Message-ID: 200002191513.HAA01493@www.geocrawler.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

This message was sent from Geocrawler.com by "Nicholas Negulescu" <negulen(at)eou(dot)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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom 2000-02-19 22:55:43 Backend terminated abnormally error ?
Previous Message Howie 2000-02-19 11:38:35 Re: [GENERAL] Deleting large objects sans index