Directing the result of EXPLAIN to a file

From: Ludwig Lim <lud_nowhere_man(at)yahoo(dot)com>
To: PostgreSQL Mailing List <pgsql-novice(at)postgresql(dot)org>
Subject: Directing the result of EXPLAIN to a file
Date: 2002-09-28 05:33:02
Message-ID: 20020928053302.36330.qmail@web80307.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Browse pgsql-novice by date

  From Date Subject
Next Message Ludwig Lim 2002-09-28 07:28:50 Is this error message PostgreSQL related?
Previous Message D. A. 2002-09-28 01:36:01 "order by" days of the week