| From: | Stephen Byers <stephenabyers(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | binary copy timestamps with libpq |
| Date: | 2006-10-19 03:38:19 |
| Message-ID: | 20061019033819.39500.qmail@web30709.mail.mud.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
I am using postgres 8.1.4 and am trying to use the binary copy interface via libpq (PQputCopyData, PQputCopyEnd). I am having trouble doing the copy for timestamp fields.
I have tried a few different ways, setting the paramFormat to 0 (ASCII) and paramType to OID_TIMESTAMP (1114). I've tried various strings, quoted and unquoted, also with "::timestamp" as part of the string -- but I am having no luck at getting the data to insert. ('2006-10-19 05:26:00'::timestamp)
What am I doing wrong? Is ASCII supported for timestamp type in binary copy mode? If not, how do I convert my timestamp to postgres's format (I am using default settings)
(I am also having the same trouble with the interval data type.)
Any help most appreciated!
Thanks,
Steve
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Byers | 2006-10-19 03:53:29 | binary copy timestamps with libpq |
| Previous Message | Marko Bozikovic | 2006-10-18 07:06:32 | Postgres OLE DB provider - query parameters |