Postgres Pro
Downloads
Home   >   mailing lists

Re: Query prepared plan - Mailing list pgsql-sql

From Alvaro Herrera
Subject Re: Query prepared plan
Date
Msg-id 20080728230824.GF14617@alvh.no-ip.org
Whole thread Raw
In response to Re: Query prepared plan  (Emi Lu <emilu@encs.concordia.ca>)
Responses Re: Query prepared plan  (Emi Lu <emilu@encs.concordia.ca>)
List pgsql-sql
Tree view 
Emi Lu wrote:

> Similar to \dt to show all tables, within one session, may I know the  
> command to list all prepared query plan please?

select * from pg_prepared_statements;

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-sql by date:

Previous
From: Milan Oparnica
Date:
Subject: Re: PERSISTANT PREPARE (another point of view)
Next
From: Lennin Caro
Date:
Subject: Re: Encrytion in postgres field in table