Обсуждение: Protocol & Transmitted Field Data
| Hi everyone, I have a question regarding field format used to transmit data (when data is transmitted over the protocol): Is there a way to change field format used by database to transmit data from text to binary? Whats happening: I have 2 columns in a table, both integers, when they transmitted over to client, their values transmitted as a collection of characters e.g. number 1234567 represented as '1' '2' '3' '4' '5' '6' '7' instead of using 4 bytes for int4 Thanks! |
On Sun, Jul 04, 2010 at 04:00:25PM +0000, Greg wrote: > Hi everyone, > > I have a question regarding field format used to transmit data (when data is transmitted over the protocol): Is there away to change field format used by database to transmit data from text to binary? > > Whats happening: I have 2 columns in a table, both integers, when they transmitted over to client, their values transmittedas a collection of characters e.g. number 1234567 represented as '1' '2' '3' '4' '5' '6' '7' instead of using4 bytes for int4 > > Thanks! > You need to use PQexecParams() with binary parameters. You can also request the results in either binary or text: http://www.postgresql.org/docs/9.0/static/libpq-exec.html Cheers, Ken
| Thanks! --- On Sun, 4/7/10, Kenneth Marshall <ktm@rice.edu> wrote:
|