Re: libpq: binary data vs textual - Mailing list pgsql-general

From Andy Colson
Subject Re: libpq: binary data vs textual
Date
Msg-id 4D3309B0.60501@squeakycode.net
Whole thread Raw
In response to libpq: binary data vs textual  (Вячеслав Блинников <slavmfm@gmail.com>)
Responses Re: libpq: binary data vs textual
List pgsql-general
On 01/16/2011 08:13 AM, Вячеслав Блинников wrote:
> Database returns information from "integer" and "biging" fields as
> text (values represented as string which must be read via
> atoi()/atol()) - is there a way to retrieve such data as binary? Will
> not PostgreSQL suddenly start return information in binary format
> (while I will continue read it as text)?

I assume you mean using libpq.

0) yes, you can get it as binary.
1) no, it wont switch.
2) you get to specify what format the server will return info, when you use PQexecParams().

See the paramFormats argument.

http://www.postgresql.org/docs/current/interactive/libpq-exec.html#LIBPQ-EXEC-MAIN

-Andy

pgsql-general by date:

Previous
From: Вячеслав Блинников
Date:
Subject: libpq: binary data vs textual
Next
From: Andy Colson
Date:
Subject: Re: libpq: binary data vs textual