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

Поиск
Список
Период
Сортировка
Искать
От
Pavel Stehule
Тема
[HACKERS] proposal: psql statements \gstore \gstore_binary (instead COPY RAW)
Дата
Msg-id
CAFj8pRAsSzV96WrHj+E3Hn2GbWwyaOdQNpLc2sfZbtOjwNEEww@mail.gmail.com
Список
Дерево обсуждения
[HACKERS] proposal: psql statements \gstore \gstore_binary (instead COPY RAW) Pavel Stehule <pavel.stehule@gmail.com>
Re: [HACKERS] proposal: psql statements \gstore \gstore_binary (instead COPY RAW) Pavel Stehule <pavel.stehule@gmail.com>
Re: [HACKERS] proposal: psql statements \gstore \gstore_binary (instead COPY RAW) Pavel Stehule <pavel.stehule@gmail.com>
Re: [HACKERS] proposal: psql statements \gstore \gstore_binary(instead COPY RAW) Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: [HACKERS] proposal: psql statements \gstore \gstore_binary(instead COPY RAW) Andrew Dunstan <andrew@dunslane.net>
Re: [HACKERS] proposal: psql statements \gstore \gstore_binary(instead COPY RAW) Pavel Stehule <pavel.stehule@gmail.com>
Re: [HACKERS] proposal: psql statements \gstore \gstore_binary(instead COPY RAW) Pavel Stehule <pavel.stehule@gmail.com>
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
В списке pgsql-hackers по дате отправления
Предыдущее
От: Merlin Moncure
Дата:
Следующее
От: David G. Johnston
Дата:
FAQ