Re: libpq: binary data vs textual

From: Andy Colson <andy(at)squeakycode(dot)net>
To: Вячеслав Блинников <slavmfm(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: libpq: binary data vs textual
Date: 2011-01-16 15:07:28
Message-ID: 4D3309B0.60501@squeakycode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Colson 2011-01-16 15:11:07 Re: libpq: binary data vs textual
Previous Message Вячеслав Блинников 2011-01-16 14:13:01 libpq: binary data vs textual