| From: | Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> |
|---|---|
| To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: proposal: psql statements \gstore \gstore_binary (instead COPY RAW) |
| Date: | 2016-12-10 01:27:21 |
| Message-ID: | dba1dfaa-a304-c996-cec7-ae93c2ab8d1c@BlueTreble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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...
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2016-12-10 02:00:01 | Re: proposal: psql statements \gstore \gstore_binary (instead COPY RAW) |
| Previous Message | Andres Freund | 2016-12-09 23:26:47 | Re: Macro customizable hashtable / bitmapscan & aggregation perf |