"Jens Schipkowski" <jens.schipkowski@xxxxxxxxxx> 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
