I have an individual text string of 2 GB.
I may use Postgresql 8.4 also. But what data type should I use to store this column value of 2GB?
On Sun, Jan 17, 2010 at 12:08 PM, Craig Ringer
<craig@postnewspapers.com.au> wrote:
On 17/01/2010 1:51 PM, AI Rumman wrote:
Hello all,
I have to store 2 GB text in the database. Previously I was using Oracle
database with CLOB data type.
Or do you mean you have a bunch of smaller (how big?) text objects that add up to 2GB or so?
Assuming you mean individual objects >= 2GB, you'll have to use PostgreSQL BLOBs or use external files.
What do you need to do with this text? What operations are you performing on it? Full-text search? Could anyone please tell me how can I do it in Postgresql 8.0 or later?
--
Craig Ringer