A few months ago, I blogged about the difficulty of getting psql to put
a bytea datum into a file. See
<http://people.planetpostgresql.org/andrew/index.php?/archives/196-Clever-trick-challenge.html>.
Today I ran into the problem again, and it struck me that we could
fairly easily have a new command to handle this, called, say, bcopy. So
it would look like:
\bcopy (select generate_bytea()) to foo.bin
Thoughts?
cheers
andrew