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!

https://github.com/reactiverse/reactive-pg-client/pull/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 [email protected] 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 https://github.com/eclipse-vertx/vertx-sql-client/issues/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 :)

[Ryaryu]

I know it is annoying to bump this just to ask, but you guys got the time to revive this?

[jlnme]

Hello everyone, I would also love this feature to be included. Any chance we get this?

[vietj]

I set help-wanted on this issue as we need a contributor to step up and implement it.

[psolomin]

Hello @vietj

Are you aware if anyone is working on this at the moment? If no, I would like to assign myself to this.

[vietj]

nobody is currently contributing this, so you can definitely take it.

you should come on our discord to discuss the feature

On Sun, Apr 16, 2023 at 12:23 AM psolomin @.***> wrote:

Hello @vietj https://github.com/vietj

Are you aware if anyone is working on this at the moment? If no, I would like to assign myself to this.

— Reply to this email directly, view it on GitHub https://github.com/eclipse-vertx/vertx-sql-client/issues/153#issuecomment-1509989627, or unsubscribe https://github.com/notifications/unsubscribe-auth/AABXDCVEMX64763YLOIQ33LXBMNXFANCNFSM4FQ73ASA . You are receiving this because you were mentioned.Message ID: @.***>