Nicolas Paris wrote on 07.02.2015 15:14:
Hello !
My goal is to get the result from "COPY TO ..." query, from JDBC. This query
returns : COPY X
(where X is number line inserted)
1) Can I can I consider it useless, since when no error, all lines are suposed
to be inserted ?
2) If not useless, how can I get the response "COPY 10" (when 10 rows
inserted), I get with psql way, or with pgadmin.
I have tried the int Statement.executeUpdate() method, but it returns 0
Thanks for any help !
Nicolas PARIS
I you are using COPY to import a file located on the server, I don't think
you'll get that information from JDBC.
But you can use the equivalent to "COPY .. FROM stdin" through JDBC.
And when you do that, you can get the number of rows inserted:
https://jdbc.postgresql.org/documentation/publicapi/org/postgresql/copy/CopyManager.html
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
