Обсуждение: Directing the result of EXPLAIN to a file

Поиск
Список
Период
Сортировка

Directing the result of EXPLAIN to a file

От
Ludwig Lim
Дата:
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