Re: really quick multiple inserts can use COPY?

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

"Jens Schipkowski" <jens(dot)schipkowski(at)apus(dot)co(dot)at> writes:
> Is it possible to use COPY FROM STDIN with JDBC?

You should be asking the pgsql-jdbc list, not here.  (I know I've seen
mention of a JDBC patch to support COPY, but I dunno if it's made it into
any official version.)

> Will it bring performance improvement compared to SELECT UNION solution?

Please, at least be smart enough to use UNION ALL not UNION.

If you're using 8.2 you could also consider using INSERT with multiple
VALUES-lists.

			regards, tom lane