Re: [HACKERS] Add support for tuple routing to foreign partitions - Mailing list pgsql-hackers

On 2017/08/17 20:37, Ashutosh Bapat wrote:
> On Thu, Aug 17, 2017 at 1:57 PM, Etsuro Fujita
> <fujita.etsuro@lab.ntt.co.jp> wrote:
>> I spent some time on this.  To handle that, I'd like to propose doing
>> something similar to \copy (frontend copy): submit a COPY query "COPY ...
>> FROM STDIN" to the remote server and route data from a file to the remote
>> server.  For that, I'd like to add new FDW APIs called during CopyFrom that
>> allow us to copy to foreign tables:
> 
> The description seems to support only COPY to a foreign table from a
> file, but probably we need the support other way round as well. This
> looks like a feature (support copy to and from a foreign table) to be
> handled by itself.

Agreed.  I'll consider how to handle copy-from-a-foreign-table as well.

Best regards,
Etsuro Fujita