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



--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to