Hi,
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
thetimestamp value, that value is interpreted by PostgreSQL in a manner I could not understand; as the result I get
wrongtimestamp value in the table.
My question is: what input binary format of a timestamp value should I use?
Thanks a lot for any suggestions,
Vlad