Working with large text blocks

On Fri, Jan 26, 2001 at 01:45:33PM -0600, Clinton James wrote:

I have some blocks of text than can be from 2K to 80K in size. I understand
7.1 will have compression to use with text, but does anyone know of a way I
can use these large text blocks as a field?

The unlimited row width feature in 7.1, aka TOAST (the best thing since
sliced bread), works transparently, so in actual fact, you can have your
text in a text field. You won't notice anything of the compression, if
TOAST decides it is needed.

Regards, Frank

The field data type is TEXT. I don't think you need to do anything special
(as long as you are using 7.1).

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "Clinton James" <cjames@callone.net>
To: <pgsql-general@postgresql.org>
Sent: Friday, January 26, 2001 2:45 PM
Subject: [GENERAL] Working with large text blocks

I have some blocks of text than can be from 2K to 80K in size. I

understand

7.1 will have compression to use with text, but does anyone know of a way

I

can use these large text blocks as a field? I'll have Win NT as a client
getting the data from a Linux box through ODBC so BLOBs don't appear a

good