Postgres Pro
Downloads
Home   >   mailing lists

Re: COPY FROM WHEN condition - Mailing list pgsql-hackers

From Corey Huinker
Subject Re: COPY FROM WHEN condition
Date
Msg-id CADkLM=dmvGSpZ+h_CzFoGeuzH7mZT3TLttx-ikc+UYw_e6L2jg@mail.gmail.com
Whole thread Raw
In response to Re: COPY FROM WHEN condition  (Surafel Temesgen <surafel3000@gmail.com>)
Responses Re: COPY FROM WHEN condition  (David Fetter <david@fetter.org>)
List pgsql-hackers
Tree view
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 FROM

regards
Surafel

It didn't get far, but you may want to take a look at a rejected patch for copy_srf() (set returning function)

Having a set returning function gives you the full expressiveness of SQL, at the cost of an extra materialization step.


 

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: out-of-order XID insertion in KnownAssignedXids
Next
From: Konstantin Knizhnik
Date:
Subject: Few remarks on JIT , parallel query execution and columnar store...