| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | maria s | 2008-07-29 16:06:57 | column names with - and ( |
| Previous Message | Lennin Caro | 2008-07-29 03:26:19 | Re: Encrytion in postgres field in table |