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