Re: RowDescription via the SQL? - Mailing list pgsql-general

From Dmitry Igrishin
Subject Re: RowDescription via the SQL?
Date
Msg-id CAAfz9KNB8HFpH=YM1wJrvfM=4YGb6zZUy3cFv0VW3Sqz5OLugg@mail.gmail.com
Whole thread Raw
In response to Re: RowDescription via the SQL?  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
2016-06-03 1:55 GMT+03:00 Merlin Moncure <mmoncure@gmail.com>:
> On Thu, Jun 2, 2016 at 1:14 AM, Dmitry Igrishin <dmitigr@gmail.com> wrote:
>> Hi,
>>
>> It's possible to query pg_prepared_statements view to obtain the
>> information about
>> parameters used in the statement that was prepared. But I don't found
>> how to get the
>> information about the rows that will be returned when the statement is
>> eventually executed.
>> (It's possible to get this information via the frontend/backend
>> protocol as a response
>> on the Describe.) But out of interest, is it possible to get such
>> information via the SQL?
>
> hm. what's the use case?
It's about consistency. It's possible to prepare the statement either
via SQL and fe/be protocol , it's possible to get the information
about parameters of prepared statement either via SQL and fe/be
protocol, but getting the information about the resulting rows is only
possible via the fe/be protocol.

>  and, what's the definition of "eventually"?
I borrowed this definition from here
https://www.postgresql.org/docs/9.6/static/protocol-flow.html#PROTOCOL-FLOW-EXT-QUERY
(The Describe message (statement variant) ...)

--
// Dmitry.


pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: How SQL SELECT * statement works in Postgres?
Next
From: Michael Paquier
Date:
Subject: Re: WAL's listing in pg_xlog by some sql query