2016-06-03 1:55 GMT+03:00 Merlin Moncure <mmoncure@xxxxxxxxx>: > On Thu, Jun 2, 2016 at 1:14 AM, Dmitry Igrishin <dmitigr@xxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
