Skip site navigation (1) Skip section navigation (2)

proposal: copybytea command for psql

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: proposal: copybytea command for psql
Date: 2012-02-16 20:06:02
Message-ID: 4F3D61AA.5000209@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-hackers
A while ago I went looking for nice ways to export an unencoded bytea 
value using psql, see 
<http://people.planetpostgresql.org/andrew/index.php?/archives/196-Clever-trick-challenge.html>. 
Regina Obe is also in want of a solution for this: 
<http://www.postgresonline.com/journal/archives/243-PSQL-needs-a-better-way-of-outputting-bytea-to-binary-files.html>.

It seems like what we need is a psql command for it, something like:

    \copybytea (select query_returning_one_bytea) to /path/to/file


Does anyone have a better solution or any objection to this feature?

cheers

andrew

Responses

pgsql-hackers by date

Next:From: Josh BerkusDate: 2012-02-16 20:06:06
Subject: Re: possible new option for wal_sync_method
Previous:From: Marti RaudseppDate: 2012-02-16 19:49:43
Subject: Re: possible new option for wal_sync_method

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group