TOAST and TEXT

From: Chris Bitmead <chris(at)bitmead(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: TOAST and TEXT
Date: 2001-10-10 01:33:04
Message-ID: 3BC3A550.9060809@bitmead.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Rod Taylor 2001-10-10 01:45:23 Re: TOAST and TEXT
Previous Message Tatsuo Ishii 2001-10-10 01:18:42 row value constructor bug?