TOAST and TEXT - Mailing list pgsql-hackers

From Chris Bitmead
Subject TOAST and TEXT
Date
Msg-id 3BC3A550.9060809@bitmead.com
Whole thread Raw
Responses Re: TOAST and TEXT
Re: TOAST and TEXT
List pgsql-hackers
Hi,

Now that postgresql doesn't have field size limits, it seems to
me they should be good for storing large blobs, even if it means
having to uuencode them to be non-binary or whatever. I don't
like the old large object implementation, I need to store very large
numbers of objects and unless this implementation has changed
in recent times it won't cut it.

So my question is, I assume TEXT is the best data type to store
large things in, what precisely is the range of characters that
I can store in TEXT? Is it only characters ascii <= 127, or is
it only printable characters, or everything except '\0' or what?



pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: row value constructor bug?
Next
From: "Rod Taylor"
Date:
Subject: Re: TOAST and TEXT