Re: [GENERAL] Using BLOBs with PostgreSQL

> > 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.

'a\\0b' put a, NULL, b.  You need double-backslash to get one backslash
to the backend.

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