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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers