Thread: what is it that \d actually does

It seems that I recall there is a way to display the actual select
statement that is executed when you execute the \d command.

Anyone?

--
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin

On Jan 25, 2008 1:34 PM, Geoffrey <lists@serioustechnology.com> wrote:
> It seems that I recall there is a way to display the actual select
> statement that is executed when you execute the \d command.

psql --help says:

  -E              display queries that internal commands generate

psql -E

On Jan 25, 2008 2:41 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Jan 25, 2008 1:34 PM, Geoffrey <lists@serioustechnology.com> wrote:
> > It seems that I recall there is a way to display the actual select
> > statement that is executed when you execute the \d command.
>
> psql --help says:
>
>   -E              display queries that internal commands generate

also, you can log statements to the server with log_statement.  psql
-E is probably better though.

merlin