Re: libpq -- reading a timestamp with time zone using binary format - Mailing list pgsql-general

From Whit Armstrong
Subject Re: libpq -- reading a timestamp with time zone using binary format
Date
Msg-id 8ec76080903231625jf4d780s77bf0cf88ddbbb07@mail.gmail.com
Whole thread Raw
In response to Re: libpq -- reading a timestamp with time zone using binary format  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Thanks, Tom.

That's just what I needed.

-Whit


On Mon, Mar 23, 2009 at 7:15 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Whit Armstrong <armstrong.whit@gmail.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
>

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: libpq -- reading a timestamp with time zone using binary format
Next
From: Tom Lane
Date:
Subject: Re: 1- and 2-dimensional indexes on same column: why is the 2d one preferred?