From: Thue Janus Kristensen <thuejk@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Getting a list of prepared statements
Date: Sun, 28 Dec 2008 23:26:54 +0100
Message-ID: <2fa647f60812281426r604fd231h88a62e66bd13b402@mail.gmail.com> (raw)
In-Reply-To: <11714.1230502529@sss.pgh.pa.us>
References: <2fa647f60812280419t3c54d14bgd1612354e789b50c@mail.gmail.com>
<11714.1230502529@sss.pgh.pa.us>
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: thuejk@gmail.com, tgl@sss.pgh.pa.us
Subject: Re: Getting a list of prepared statements
In-Reply-To: <2fa647f60812281426r604fd231h88a62e66bd13b402@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox