COPY command

[yonigibbs]

Hi @vietj. Is it possible to run a COPY command through reactive-pg-client? Specifically, to load a CSV of data in what I believe is the most efficient way to load a large number of records into the system. I believe the CSV has to either be on the DB server itself (which we'd like to avoid if possible), so can we in some way use the STDIN argument of the COPY command to provide the CSV file over the wire to it?

Thanks!

[vietj]

@yonigibbs no it has not been implemented as far as I know, this is a part of the postgresl protocol I'm not familiar (yet) with - but it is planned to be implemented

[vietj]

copy seems indeed to be a stream oriented operation (in both ways), I believe it can be implemented fairly easily.

[yonigibbs]

Great, thanks. We'll keep an eye out for it being implemented in future.

[davidzzzzz]

@vietj did anyone volunteer for this? Otherwise, I think we'd like to take it on

[vietj]

@davidzzzzz it's all yours if you take it

[davidzzzzz]

Great, on it

[davidzzzzz]

@vietj Here's the direction I've taken with supporting COPY FROM operations. Please provide feedback before I add more documentation and polish. Thanks!

#205

[bchapuis]

Hi @vietj and @davidzzzzz, I'm really interested in experimenting with COPY FROM. As #205 is closed what's the current status?

[Globegitter]

Yeah same here @vietj - what exactly happened with the PR that added the COPY command? IT seems it got swallowed by the 3.8 release. Any plans to bring it back?

[vietj]

@Globegitter I think it simply got lost, it should be rebased on latest 3.8 indeed

[davidzzzzz]

If there's interest @vietj, I'm happy to revive this

[vietj]

yes there is, sorry for letting this dormant

…

On 9 Sep 2019, at 04:35, David Zuckerman ***@***.***> wrote: If there's interest @vietj <https://github.com/vietj>, I'm happy to revive this — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#153?email_source=notifications&email_token=AABXDCXZKPKTWJZ6XDEU23TQIWY6PA5CNFSM4FQ73ASKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD6GCMRA#issuecomment-529278532>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AABXDCQP6PHU7F7KMFHHE7LQIWY6PANCNFSM4FQ73ASA>.

[Globegitter]

@davidzzzzz any chance this can be revived again?

[davidzzzzz]

@Globegitter sorry about that, my day job got in the way :) Hoping to get to this shortly

[Globegitter]

@davidzzzzz No worries, I know the feeling :)