Postgres Pro
Downloads
Home   >   mailing lists

Re: Question: Select messages using binary format - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Question: Select messages using binary format
Date
Msg-id CAFj8pRBb58V4PGFCq1Yj+vPUr=0nOJqFNVFpmch7C_TMY-Pc5Q@mail.gmail.com
Whole thread Raw
In response to Question: Select messages using binary format  (Aleksei Ivanov <iv.alekseii@gmail.com>)
List pgsql-hackers
Tree view
Hi

so 7. 3. 2020 v 8:38 odesílatel Aleksei Ivanov <iv.alekseii@gmail.com> napsal:
Dear hackers,

I know that it is possible to receive packets in binary format using declare binary cursor and than fetching the result.

But is it possible just using ordinary select from simple query to specify that I want to receive the result in binary?

It depends on interface that you use. C API - libpq allow to specify type of communication per query


PQexecParams resultFormat

What I known, you cannot to do from SQL level.

Regards

Pavel


Best regards,

pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: pgbench: option delaying queries till connectionsestablishment?
Next
From: Vladimir Sitnikov
Date:
Subject: Re: Questions about the CI process and proposal