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