| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Aleksei Ivanov <iv(dot)alekseii(at)gmail(dot)com> |
| Cc: | "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Question: Select messages using binary format |
| Date: | 2020-03-07 08:51:48 |
| Message-ID: | CAFj8pRBb58V4PGFCq1Yj+vPUr=0nOJqFNVFpmch7C_TMY-Pc5Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi
so 7. 3. 2020 v 8:38 odesílatel Aleksei Ivanov <iv(dot)alekseii(at)gmail(dot)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
https://www.postgresql.org/docs/current/libpq-exec.html
PQexecParams *resultFormat*
What I known, you cannot to do from SQL level.
Regards
Pavel
> Best regards,
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vladimir Sitnikov | 2020-03-07 09:12:05 | Re: Questions about the CI process and proposal |
| Previous Message | Fabien COELHO | 2020-03-07 08:30:31 | Re: pgbench: option delaying queries till connections establishment? |