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

On Dec 9, 2016 18:40, "Pavel Stehule" <pavel.stehule@gmail.com> 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 and I propose \gstore for storing result in file and \gstore_binary for storing result in file with binary passing. The query result should be one row, one column.

Usage:

SELECT image FROM accounts WHERE id = xxx

\gstore_binary ~/image.png

What do you think about this proposal?

I might be missing something, but is it different from:

\t

\a

\o output_filename

SELECT ...

\o

?

--

Alex