pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Stephen Byers <stephenabyers@yahoo.com>
To: pgsql-interfaces@postgresql.org
Subject: Re: binary copy timestamps with libpq
Date: Thu, 19 Oct 2006 05:15:59 -0700 (PDT)
Message-ID: <20061019121559.6754.qmail@web30714.mail.mud.yahoo.com> (raw)

I just discovered PGTYPEStimestamp_from_asc(). 
I'm sure that will help me -- is this the correct method to use?


----- Original Message ----
From: Stephen Byers <stephenabyers@yahoo.com>
To: pgsql-interfaces@postgresql.org
Sent: Wednesday, October 18, 2006 11:38:19 PM
Subject: [INTERFACES] binary copy timestamps with libpq


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



view thread (3+ messages)

Message-ID: <20061019121559.6754.qmail@web30714.mail.mud.yahoo.com>
Permalink:  ../20061019121559.6754.qmail@web30714.mail.mud.yahoo.com/
Also on:    postgresql.org/message-id/20061019121559.6754.qmail@web30714.mail.mud.yahoo.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: stephenabyers@yahoo.com
  Subject: Re: binary copy timestamps with libpq
  In-Reply-To: <20061019121559.6754.qmail@web30714.mail.mud.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox