From: | Владимир Баранов <baranoff(at)inbox(dot)ru> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | COPY <table> FROM STDIN BINARY |
Date: | 2007-08-17 11:38:40 |
Message-ID: | E1IM0A4-000BYC-00.baranoff-inbox-ru@f31.mail.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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 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,
Vlad
From | Date | Subject | |
---|---|---|---|
Next Message | Vance Maverick | 2007-08-19 06:09:30 | fyi: reading large BYTEA |
Previous Message | Marek Lewczuk | 2007-08-17 08:04:49 | AbstractJdbc2Array rewritten code |