Re: Getting a list of prepared statements - Mailing list pgsql-interfaces

From Thue Janus Kristensen
Subject Re: Getting a list of prepared statements
Date
Msg-id 2fa647f60812281426r604fd231h88a62e66bd13b402@mail.gmail.com
Whole thread Raw
In response to Re: Getting a list of prepared statements  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-interfaces
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@sss.pgh.pa.us> wrote:
"Thue Janus Kristensen" <thuejk@gmail.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

pgsql-interfaces by date:

Previous
From: Tom Lane
Date:
Subject: Re: Getting a list of prepared statements
Next
From: Raimon Fernandez
Date:
Subject: Re: new ruby-pg release: support for ruby 1.9