COPY
Issue #5
new
I have worked out using the libpq library to send data using the COPY command. I would like to share my work with the PQ LabVIEW project:
@James Powell @antoinechalons please let me know next steps regarding pulling changes, etc.
Comments (5)
-
-
-
assigned issue to
Antoine Chalons
-
assigned issue to
-
reporter
@Antoine you can see my code here. It is based on your most recent commit. I needed to back save to LV 2016, but I don’t think there should be any issues opening in 2017.
-
reporter
Antoine, I found your MultiValue INSERT example and I like it very much. Here I’ve added benchmarks for the various upload methods. I found that Multirow INSERT and COPY are similar up to 100,000 rows, but INSERT failed for 1,000,000 rows. COPY really shines if the data already exists in a TSV/CSV file:
Time for INSERT and “COPY Data” includes data to string conversion, so the comparison probably isn’t entirely fair.
-
reporter
asynchronous libpq-copy (https://www.postgresql.org/docs/current/libpq-copy.html) is implemented in COPY.vi
- Log in to comment
thanks for reporting this, I’ll take a look.