Обсуждение: extended view of sql

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

extended view of sql

От
Jodi Kanter
Дата:
I seem to remember there being a switch that I could set in psql that would show me the sql that the system is using when I run certain commands. For example, what the system is doing when I do a \d tablename.
Does anyone know what I am referring to? I cannot seem to find anything in the docs but then I don't know what its called so cannot search.
Thanks
Jodi
--

_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu


 

 

 

Re: extended view of sql

От
Bruno Wolff III
Дата:
On Wed, Sep 10, 2003 at 14:09:25 -0400,
  Jodi Kanter <jkanter@virginia.edu> wrote:
> I seem to remember there being a switch that I could set in psql that
> would show me the sql that the system is using when I run certain
> commands. For example, what the system is doing when I do a \d tablename.
> Does anyone know what I am referring to? I cannot seem to find anything
> in the docs but then I don't know what its called so cannot search.

You probably want the -E option. Documentation on it is in the man page
for psql.