Re: Getting a list of prepared statements
От | Thue Janus Kristensen |
---|---|
Тема | Re: Getting a list of prepared statements |
Дата | |
Msg-id | 2fa647f60812281426r604fd231h88a62e66bd13b402@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Getting a list of prepared statements (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-interfaces |
Ah - thanks. :)<br /><br />I must be trusting too much in Google, because all Google returned was a pages telling me thatit could not be done. But now I see that it is described clearly at the obvious location, <a href="http://www.postgresql.org/docs/8.3/interactive/sql-prepare.html">http://www.postgresql.org/docs/8.3/interactive/sql-prepare.html</a> :-/<br/><br />However, this won't be a problem in the future, for already the top hit on Google for "postgresql get listof prepared statements" is this email thread, with me asking stupid questions the answer to which is clearly visiblein the manual *hmm*.<br /><br />Regards, Thue<br /><br /><div class="gmail_quote">On Sun, Dec 28, 2008 at 11:15 PM,Tom Lane <span dir="ltr"><<a href="mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>></span> wrote:<br /><blockquoteclass="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left:1ex;"><div class="Ih2E3d">"Thue Janus Kristensen" <<a href="mailto:thuejk@gmail.com">thuejk@gmail.com</a>>writes:<br /> > It would be very nice to have a way to get a listof prepared statements.<br /> > Currently there does not seem to be any: [1]<br /><br /></div>select * from pg_prepared_statements?<br /><br /> (exists since 8.2)<br /><br /> regards, tom lane<br /></blockquote></div><br/>
В списке pgsql-interfaces по дате отправления: