Re: COPY FROM WHEN condition
| От | Corey Huinker |
|---|---|
| Тема | Re: COPY FROM WHEN condition |
| Дата | |
| Msg-id | CADkLM=dmvGSpZ+h_CzFoGeuzH7mZT3TLttx-ikc+UYw_e6L2jg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: COPY FROM WHEN condition (Surafel Temesgen <surafel3000@gmail.com>) |
| Ответы |
Re: COPY FROM WHEN condition
|
| Список | pgsql-hackers |
On Thu, Oct 11, 2018 at 5:04 AM Surafel Temesgen <surafel3000@gmail.com> wrote:
On Thu, Oct 11, 2018 at 12:00 PM Christoph Moench-Tegeder <cmt@burggraben.net> wrote:You can:
COPY ( query ) TO 'filename';it is for COPY FROMregardsSurafel
It didn't get far, but you may want to take a look at a rejected patch for copy_srf() (set returning function)
https://www.postgresql.org/message-id/CADkLM%3DdoeiWQX4AGtDNG4PsWfSXz3ai7kY%3DPZm3sUhsUeev9Bg%40mail.gmail.com
https://commitfest.postgresql.org/12/869/
https://commitfest.postgresql.org/12/869/
Having a set returning function gives you the full expressiveness of SQL, at the cost of an extra materialization step.
В списке pgsql-hackers по дате отправления: