Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 380A864FC70
	for <pgsql-interfaces-postgresql.org@mail.postgresql.org>;
	Sun, 28 Dec 2008 18:26:59 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 87763-05
	for <pgsql-interfaces-postgresql.org@mail.postgresql.org>;
	Sun, 28 Dec 2008 18:26:56 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from qw-out-2122.google.com (qw-out-2122.google.com [74.125.92.26])
	by mail.postgresql.org (Postfix) with ESMTP id 1D88A64FC18
	for <pgsql-interfaces@postgresql.org>;
	Sun, 28 Dec 2008 18:26:55 -0400 (AST)
Received: by qw-out-2122.google.com with SMTP id 8so1667789qwh.61
	for <pgsql-interfaces@postgresql.org>;
	Sun, 28 Dec 2008 14:26:54 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:cc:in-reply-to:mime-version:content-type:references;
	bh=ThnOjbS98ORidWr+0NguMGfQ5UAQg+a5wba1qcWqkAs=;
	b=CUB3hWkTSwfyHfeYuwFEQJYNk0HjyoHqb9lO0nQMWi27xd8EAa+worPNo0nACtFJtB
	V3iMO3Ppsyv58ZTeFOgv8ne6o7zaUwoaZZpwRhtJgqTzUAUSOEg9aV/kGmowQvHhf/mE
	Itb2vpCKKxJ2v4jxsI1DXqw6rz27mt7Y5oX0g=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:references;
	b=qFJmrikQisFD7ezBXqF0ag8ea4HZAj1k/OU6SrWmpLXBrSb4TTRW/F2FacWWL2b1jp
	NcBcOmt451TwUj4VIhH+X/rgi8ETJyH1Pr+sXgX69SNXbtGD2dmoEIQcbA1d7/P3G7EL
	rUmlpjWJx/DyXb3/8dB8Tcec3YEenIhdjYWj4=
Received: by 10.215.101.10 with SMTP id d10mr10673958qam.225.1230503214800;
	Sun, 28 Dec 2008 14:26:54 -0800 (PST)
Received: by 10.215.40.21 with HTTP; Sun, 28 Dec 2008 14:26:54 -0800 (PST)
Message-ID: <2fa647f60812281426r604fd231h88a62e66bd13b402@mail.gmail.com>
Date: Sun, 28 Dec 2008 23:26:54 +0100
From: "Thue Janus Kristensen" <thuejk@gmail.com>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Subject: Re: Getting a list of prepared statements
Cc: pgsql-interfaces@postgresql.org
In-Reply-To: <11714.1230502529@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_135049_31475048.1230503214786"
References: <2fa647f60812280419t3c54d14bgd1612354e789b50c@mail.gmail.com>
	<11714.1230502529@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200812/22
X-Sequence-Number: 6839

------=_Part_135049_31475048.1230503214786
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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
>

------=_Part_135049_31475048.1230503214786
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Ah - thanks. :)<br><br>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, <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&#39;t be a problem in the future, for already the top hit on Google for &quot;postgresql get list of prepared statements&quot; is this email thread, with me asking stupid questions the answer to which is clearly visible in 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">&lt;<a href="mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="Ih2E3d">&quot;Thue Janus Kristensen&quot; &lt;<a href="mailto:thuejk@gmail.com">thuejk@gmail.com</a>&gt; writes:<br>
&gt; It would be very nice to have a way to get a list of prepared statements.<br>
&gt; 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>
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;regards, tom lane<br>
</blockquote></div><br>

------=_Part_135049_31475048.1230503214786--