| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | kientzle(at)acm(dot)org |
| Cc: | "Martin A(dot) Marques" <martin(at)math(dot)unl(dot)edu(dot)ar>, PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org> |
| Subject: | Re: [GENERAL] Using BLOBs with PostgreSQL |
| Date: | 2000-10-10 00:17:14 |
| Message-ID: | 200010100017.UAA00175@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
> > 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(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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alex Pilosov | 2000-10-10 01:18:43 | Re: Oracle to POSTGRESQL |
| Previous Message | Stephan Szabo | 2000-10-10 00:08:45 | Re: Problem with NULL value in arguments of server-side functions ( plpgsql ) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Don Baccus | 2000-10-10 00:30:20 | Re: ALTER TABLE DROP COLUMN |
| Previous Message | Bruce Momjian | 2000-10-10 00:16:16 | Re: Small patch to replace 'idle' by 'trans' if transaction is still open |