Re: proposal: psql \setfileref

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Corey Huinker <corey(dot)huinker(at)gmail(dot)com>
Cc: Gilles Darold <gilles(dot)darold(at)dalibo(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: proposal: psql \setfileref
Date: 2016-10-09 16:12:16
Message-ID: CAFj8pRD6T_B2JsLOvj_DuVa_uxhiqB_J7iVjuC1MArTwf1Td+A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

2016-10-09 17:27 GMT+02:00 Corey Huinker <corey(dot)huinker(at)gmail(dot)com>:

> here is new update - some mentioned issues are fixed + regress tests and
>>> docs
>>>
>>
>>
>>
> This might tie into some work I'm doing. Is there any way these filerefs
> could be used as the inline portion of a COPY command?
> i.e. like this:
>
> COPY my_table FROM STDIN
> :file_ref
> \.
>
>
>
I understand, but I am not sure how difficult implementation it is. This
part (COPY input) doesn't support parametrization - and parametrization can
have a negative performance impact.

Regards

Pavel

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2016-10-09 16:53:34 cygwin64 assertion failure
Previous Message Corey Huinker 2016-10-09 15:27:42 Re: proposal: psql \setfileref