Home > mailing lists

Directing the result of EXPLAIN to a file - Mailing list pgsql-novice

From	Ludwig Lim
Subject	Directing the result of EXPLAIN to a file
Date	September 28, 2002 04:33:05
Msg-id	20020928053302.36330.qmail@web80307.mail.yahoo.com Whole thread Raw
List	pgsql-novice

Tree view

Hi:


  I notice that the result of the EXPLAIN dumps into
standard error. I'm unable to save the result of the
EXPLAIN with the "\o <output file>" switch inside the
psql.

  Is there a way to simulate the ff inside psql:
  psql <db> -f <filename> 2> <stderr file>


thank you in advance,
ludwig.

__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com

pgsql-novice by date:

From: Josh Berkus
Date: 27 September 2002, 18:04:10
Subject: PGSQL-Performance mailing list.

From: Ludwig Lim
Date: 28 September 2002, 06:28:54
Subject: Is this error message PostgreSQL related?

Directing the result of EXPLAIN to a file - Mailing list pgsql-novice

Previous

Next