Skip site navigation (1) Skip section navigation (2)

Re: how do i store \0 inside a text attribute?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Paul A Vixie <vixie(at)mfnx(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: how do i store \0 inside a text attribute?
Date: 2001-01-02 03:45:41
Message-ID: 200101020345.WAA06118@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
> > See bytea, though its presentation format leaves something to be desired IMHO
> > 
> > > how would someone be expected to store, say, a GIF image in a TOAST text?
> > 
> > One would not.  A TOASTed bytea is the appropriate column type.
> 
> thanks -- that's EXACTLY what i needed.
> 

bytea was not really used very much until people started asking to do
this kind of think.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2001-01-02 03:56:52
Subject: Re: PHP and PostgreSQL
Previous:From: Bruce MomjianDate: 2001-01-02 03:42:58
Subject: Re: GNU readline and BSD license

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group