Re: More info needed on TEXT data type - Mailing list pgsql-general

From Ricardo Caesar Lenzi
Subject Re: More info needed on TEXT data type
Date
Msg-id 3BBDB70D.4C63D02E@k1.com.br
Whole thread Raw
In response to More info needed on TEXT data type  (Chris Bitmead <chris@bitmead.com>)
List pgsql-general
Chris Bitmead wrote:

> I want to store binary data, but I don't
> want to use large objects. Can TEXT type
> store binary data, if not precisely what
> range of characters can be stored in it?
> Is there any other data type that would
> be better to use?

To store binary data, you should use Large Objects, and store in table
just the large object oid. For more information about Large Objects see:
http://www.us.postgresql.org/users-lounge/docs/7.1/programmer/largeobjects.html


pgsql-general by date:

Previous
From: Ellen Cyran
Date:
Subject: Problem with seeing views
Next
From: David Link
Date:
Subject: Support issues