Re: [GENERAL] Using BLOBs with PostgreSQL

Bruce Momjian wrote:
> > On Sat, 07 Oct 2000, Tim Kientzle wrote:
> > > I've been using MySQL for initial development; it has pretty
> > > clean and easy-to-use BLOB support.  You just declare a BLOB
> > > column type, then read and write arbitrarily large chunks of data.
> >
> > If you're talking about BLOB texts, just declare the column as text and thats
> > all. In the case of binary data, I don't have an idea. I only work we text
> > data.
> 
> Yes, this opens a good question.  We have long text fields, and bytea for
> binary input with escapes.  As far as I know, we can store binary values
> in text fields, but we have no way of getting them in there via SQL
> queries (except for bytea using escapes for the binary values).

"bytea for binary data with escapes"??

What would those escapes look like?  I could not find any escape
that would put a NULL character into a bytea field.
            - Tim Kientzle