Re: libpq -- reading a timestamp with time zone using binary format

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Whit Armstrong <armstrong(dot)whit(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: libpq -- reading a timestamp with time zone using binary format
Date: 2009-03-23 23:15:33
Message-ID: 4693.1237850133@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Whit Armstrong <armstrong(dot)whit(at)gmail(dot)com> writes:
> but it is still unclear (at least to me) how to determine as the
> client whether the server has been compiled with the
> HAVE_INT64_TIMESTAMP flag.

You look at the integer_datetimes parameter. You could execute a
SQL "SHOW" command, but in a libpq client it's sufficient to use
PQparameterStatus(), because this value is sent automatically
during connection startup.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Whit Armstrong 2009-03-23 23:25:30 Re: libpq -- reading a timestamp with time zone using binary format
Previous Message Tom Lane 2009-03-23 23:07:50 Re: unexpected check constraint violation