Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: libpq -- reading a timestamp with time zone using binary format
Date
Msg-id 4693.1237850133@sss.pgh.pa.us
Whole thread Raw
In response to libpq -- reading a timestamp with time zone using binary format  (Whit Armstrong <armstrong.whit@gmail.com>)
Responses Re: libpq -- reading a timestamp with time zone using binary format  (Whit Armstrong <armstrong.whit@gmail.com>)
List pgsql-general
Tree view 
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: unexpected check constraint violation
Next
From: Whit Armstrong
Date:
Subject: Re: libpq -- reading a timestamp with time zone using binary format