Query prepared plan

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Query prepared plan
Date: 2008-07-23 18:22:20
Message-ID: 488776DC.7090607@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Good morning,

May I know the "commands" to
. show current session's prepared plans
. see the definition of a prepared plan

E.g., psql> PREPARE fooplan (int, text, bool, numeric) AS INSERT INTO
foo VALUES($1, $2, $3, $4);

(1) Similar to "\dt", I want to see "fooplan"
(2) Similar to "\d tableName", how to see the plan def?

Thanks a lot!

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Maximilian Tyrtania 2008-07-24 07:43:07 Cloning hierarchical data
Previous Message Scott Marlowe 2008-07-23 14:29:58 Re: Select default values