Re: Query prepared plan

>> 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,
compiledby GCC gcc (GCC) 3.3.2