>> 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