| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | psql binary output |
| Date: | 2013-01-13 18:18:58 |
| Message-ID: | 50F2FA92.9040000@dunslane.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
I whipped this up some months ago and forgot that I hadn't sent in the
patch.
This implements two psql commands: \gb and \gbn
Both fetch and output results in binary mode - \gb uses separators,
while \gbn does not. Examples:
[andrew(at)emma inst.psql-binout.5705]$ echo "select bytea '\\x00010203', bytea '\\x040506' \\gbn" | bin/psql | od -c
0000000 \0 001 002 003 004 005 006
0000007
[andrew(at)emma inst.psql-binout.5705]$ echo "select bytea '\\x00010203', bytea '\\x040506' \\gb" | bin/psql | od -c
0000000 \0 001 002 003 | 004 005 006 \n
0000011
This is an attempt to deal with the question I originally posed here:
<http://people.planetpostgresql.org/andrew/index.php?/archives/196-Clever-trick-challenge.html>
and is based on a suggestion Tom later made (although anything wrong
here is of course my fault, not his.
If people are interested I'll try to finish this up and document it.
cheers
andrew
| Attachment | Content-Type | Size |
|---|---|---|
| psql-binout.patch | text/x-patch | 9.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2013-01-13 18:41:36 | Re: [PATCH] unified frontend support for pg_malloc et al and palloc/pfree mulation (was xlogreader-v4) |
| Previous Message | Andres Freund | 2013-01-13 18:07:33 | Re: [PATCH] unified frontend support for pg_malloc et al and palloc/pfree mulation (was xlogreader-v4) |