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

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: proposal: psql statements \gstore \gstore_binary (instead COPY RAW)
Date: 2016-12-09 17:39:50
Message-ID: CAFj8pRAsSzV96WrHj+E3Hn2GbWwyaOdQNpLc2sfZbtOjwNEEww@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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?

Regards

Pavel

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David G. Johnston 2016-12-09 17:40:12 Re: jsonb problematic operators
Previous Message Merlin Moncure 2016-12-09 17:38:09 Re: jsonb problematic operators