Skip site navigation (1) Skip section navigation (2)

Re: Query prepared plan

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL SQL List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Query prepared plan
Date: 2008-07-29 13:39:04
Message-ID: 488F1D78.3040908@encs.concordia.ca (view raw or flat)
Thread:
Lists: pgsql-sql
>> 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;

Thank you! I think this is the command.

Too bad that I could not use it under 8.0x.
select * from pg_prepared_statements;
ERROR:  relation "pg_prepared_statements" does not exist
fis=> select version();
                                  version
-------------------------------------------------------------------------
  PostgreSQL 8.0.15 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.2



In response to

pgsql-sql by date

Next:From: maria sDate: 2008-07-29 16:06:57
Subject: column names with - and (
Previous:From: Lennin CaroDate: 2008-07-29 03:26:19
Subject: Re: Encrytion in postgres field in table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group