On Dec 9, 2016 18:40, "Pavel Stehule" <pavel.steh...@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