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: rela
Emi Lu wrote:
> 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;
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt,
Tom Lane wrote:
Emi Lu <[EMAIL PROTECTED]> writes:
Somebody know about how to find prepared query plan through command line?
PREPARE fooplan(...)
EXPLAIN EXECUTE fooplan(...)
Thank you Tom.
Similar to \dt to show all tables, within one session, may I know the
command to lis
Emi Lu <[EMAIL PROTECTED]> writes:
> Somebody know about how to find prepared query plan through command line?
PREPARE fooplan(...)
EXPLAIN EXECUTE fooplan(...)
regards, tom lane
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make change
Good morning,
May I know the "commands" to
. show current session's prepared plans
. see the definition of a prepared plan
E.g., psql> PREPARE fooplan (int, text, bool, numeric) AS INSERT INTO
foo VALUES($1, $2, $3, $4);
(1) Similar to "\dt", I want to see "fooplan"
(2) Similar to "\d table
Good morning,
May I know the "commands" to
. show current session's prepared plans
. see the definition of a prepared plan
E.g., psql> PREPARE fooplan (int, text, bool, numeric) AS INSERT INTO
foo VALUES($1, $2, $3, $4);
(1) Similar to "\dt", I want to see "fooplan"
(2) Similar to "\d tableNa
