Re: [HACKERS] proposal: psql statements \gstore \gstore_binary (instead COPY RAW)

2016-12-11 Thread Pavel Stehule
2016-12-11 18:23 GMT+01:00 Pavel Stehule : > Hi > > 2016-12-09 18:39 GMT+01:00 Pavel Stehule : > >> Hi >> >> Long time I am pushing a COPY RAW - without success. >> >> Now I propose functionally similar solution - reduced to only to psql >>

Re: [HACKERS] proposal: psql statements \gstore \gstore_binary (instead COPY RAW)

2016-12-11 Thread Pavel Stehule
Hi 2016-12-09 18:39 GMT+01:00 Pavel Stehule : > Hi > > Long time I am pushing a COPY RAW - without success. > > Now I propose functionally similar solution - reduced to only to psql > console > > Now we have a statement \g for execution query, \gset for exec and store >

Re: [HACKERS] proposal: psql statements \gstore \gstore_binary (instead COPY RAW)

2016-12-10 Thread Pavel Stehule
2016-12-10 7:11 GMT+01:00 Pavel Stehule : > > > 2016-12-10 2:27 GMT+01:00 Jim Nasby : > >> 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

Re: [HACKERS] proposal: psql statements \gstore \gstore_binary (instead COPY RAW)

2016-12-09 Thread Pavel Stehule
2016-12-10 2:27 GMT+01:00 Jim Nasby : > 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

Re: [HACKERS] proposal: psql statements \gstore \gstore_binary (instead COPY RAW)

2016-12-09 Thread Andrew Dunstan
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

Re: [HACKERS] proposal: psql statements \gstore \gstore_binary (instead COPY RAW)

2016-12-09 Thread Jim Nasby
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

Re: [HACKERS] proposal: psql statements \gstore \gstore_binary (instead COPY RAW)

2016-12-09 Thread Pavel Stehule
2016-12-09 19:48 GMT+01:00 Oleksandr Shulgin : > On Dec 9, 2016 18:40, "Pavel Stehule" wrote: > > Hi > > Long time I am pushing a COPY RAW - without success. > > Now I propose functionally similar solution - reduced to only to psql > console

Re: [HACKERS] proposal: psql statements \gstore \gstore_binary (instead COPY RAW)

2016-12-09 Thread Oleksandr Shulgin
On Dec 9, 2016 18:40, "Pavel Stehule" wrote: Hi Long time I am pushing a COPY RAW - without success. Now I propose functionally similar solution - reduced to only to psql console Now we have a statement \g for execution query, \gset for exec and store result in memory

[HACKERS] proposal: psql statements \gstore \gstore_binary (instead COPY RAW)

2016-12-09 Thread Pavel Stehule
Hi Long time I am pushing a COPY RAW - without success. Now I propose functionally similar solution - reduced to only to psql console Now we have a statement \g for execution query, \gset for exec and store result in memory and I propose \gstore for storing result in file and \gstore_binary for