I have troubles with bulk insert of binary data via COPY command.
I use JDBC 3.0 driver patched by Kalle Hallivuori (http://kato.iki.fi/)
My table is:
create table bulk_data (
id integer, ts timestamp, ...
which I try to populate from Java app using COPY command:
copy bulk_data from stdin binary;
All integer, varchar and bytea values are copied correctly. But when I put into stream System.currentTimeMillis() as the timestamp value, that value is interpreted by PostgreSQL in a manner I could not understand; as the result I get wrong timestamp value in the table.
My question is: what input binary format of a timestamp value should I use?
Thanks a lot for any suggestions,
pgsql-jdbc by date
|Next:||From: Vance Maverick||Date: 2007-08-19 06:09:30|
|Subject: fyi: reading large BYTEA|
|Previous:||From: Marek Lewczuk||Date: 2007-08-17 08:04:49|
|Subject: AbstractJdbc2Array rewritten code|