2011/10/21 Andrew Dunstan <andrew.duns...@pgexperts.com>: > On 10/21/2011 02:44 PM, Pavel Stehule wrote: >> >> 2011/10/21 Andrew Dunstan<andrew.duns...@pgexperts.com>: >>> >>> 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? >> >> isn't better to fix current tools to work well with bytea? >> > > Such as?
some like \copy ... to foo.bin format binary a COPY API can do it - it support a binary load and binary dump, so just there is missing interface Pavel > > 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