Re: More info needed on TEXT data type

From: Ricardo Caesar Lenzi <ricardo(at)k1(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: More info needed on TEXT data type
Date: 2001-10-05 13:35:09
Message-ID: 3BBDB70D.4C63D02E@k1.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Link 2001-10-05 14:55:13 Support issues
Previous Message Ellen Cyran 2001-10-05 11:56:31 Problem with seeing views