Thread: extended view of sql

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

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.