Postgres Pro
Downloads
Home   >   mailing lists

Postgresql - COPY TO - get number row inserted - from JDBC - Mailing list pgsql-general

From Nicolas Paris
Subject Postgresql - COPY TO - get number row inserted - from JDBC
Date
Msg-id CA+ssMOSLA8Sf32CicK2H62hO4ZoBskqEyhx4jmjD9g9rYmq4sw@mail.gmail.com
Whole thread Raw
Responses Re: Postgresql - COPY TO - get number row inserted - from JDBC  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Postgresql - COPY TO - get number row inserted - from JDBC  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Alexey Slynko
Date:
Subject: PgConf Russia event
Next
From: Adrian Klaver
Date:
Subject: Re: Postgresql - COPY TO - get number row inserted - from JDBC