On 12/09/2016 08:27 PM, Jim Nasby wrote:
On 12/9/16 9:39 AM, Pavel Stehule wrote:
SELECT image FROM accounts WHERE id = xxx
\gstore_binary ~/image.png
What do you think about this proposal?
Seems reasonable.
I've lost track at this point... is there a way to go the other
direction with that as well? Namely, stick the contents of a file into
a field via an INSERT or UPDATE?
I've done that in the past via psql -v var=`cat file`, but there's
obviously some significant drawbacks to that...
It all looks eerily familiar ...
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
