| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | "Peter Wang" <pwang(at)voyence(dot)com>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: BYTEA output presentation |
| Date: | 2004-07-16 20:48:43 |
| Message-ID: | 200407162248.43228.peter_e@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Peter Wang wrote:
> The BYTEA data look like "/031/024/001/003?/022/....".
> How can I use some PostgreSQL function to remove "/" when I use
> select statement ? What type of format is the BYTEA datatype? Can I
> output it to hexadecimal or octal format ? If you can, how ? Or do
> you know any third party tool or script which can output the
> hexadecimal or octal format for PostgreSQL's BYTEA datatype ? Your
> help is appreciated. Thank you.
libpq has functions to deal with bytea data:
http://www.postgresql.org/docs/7.4/static/libpq-exec.html#LIBPQ-EXEC-ESCAPE-BYTEA
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rod Taylor | 2004-07-17 02:28:18 | Re: Query plan discrepancies |
| Previous Message | Peter Wang | 2004-07-16 20:18:13 | BYTEA output presentation |