psql binary output

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: Raw Message | Whole Thread | 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

Browse pgsql-hackers by date

  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)