Re: Getting a list of prepared statements

Ah - thanks. :)

I must be trusting too much in Google, because all Google returned was a
pages telling me that it could not be done. But now I see that it is
described clearly at the obvious location,
http://www.postgresql.org/docs/8.3/interactive/sql-prepare.html :-/

However, this won't be a problem in the future, for already the top hit on
Google for "postgresql get list of prepared statements" is this email
thread, with me asking stupid questions the answer to which is clearly
visible in the manual *hmm*.

Regards, Thue

On Sun, Dec 28, 2008 at 11:15 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> "Thue Janus Kristensen" <thuejk(at)gmail(dot)com> writes:
> > It would be very nice to have a way to get a list of prepared statements.
> > Currently there does not seem to be any: [1]
>
> select * from pg_prepared_statements ?
>
> (exists since 8.2)
>
> regards, tom lane
>