Re: Binary params in libpq - Mailing list pgsql-general

From Tom Lane
Subject Re: Binary params in libpq
Date
Msg-id 16741.1298992766@sss.pgh.pa.us
Whole thread Raw
In response to Re: Binary params in libpq  (Kelly Burkhart <kelly.burkhart@gmail.com>)
List pgsql-general
Kelly Burkhart <kelly.burkhart@gmail.com> writes:
> On Mon, Feb 28, 2011 at 8:42 AM, Merlin Moncure <mmoncure@gmail.com> wrote:
>> Actually, this has always been a compile time option on the server as
>> far as i remember and there is protocol support for it -- libpq tells
>> you how it has been set...you've always had to deal with this

> I don't see any libpq calls that can, at run-time, tell you things
> like what format the timestamp is and what endian-ness the server is.
> Is there something I'm missing?

The timestamp format can be determined by querying PQparameterStatus
for the value of "integer_datetimes".  Server endianness is irrelevant
because values are always sent big-endian.

            regards, tom lane

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: database is bigger after dump/restore - why? (60 GB to 109 GB)
Next
From: Tom Lane
Date:
Subject: Re: database is bigger after dump/restore - why? (60 GB to 109 GB)