PostgreSQL: Outputting query of underlying function

Someone once mentioned a way to make Postgres verbose, so that if you did \dt it would display all the underlying SQL.

I thought it was connected with -a or -e to echo the SQL, but I was wrong. I seem to have forgotten that method and have tried to look it up without any luck: http://www.postgresql.org/docs/current/static/app-psql.html


Edit:

I thought because this was database/sql related it was for stackoverflow, but this may need to be moved to [Super Users|Server Fault|Database Administrators] (?)

Answers


snipped from the output of psql --help:

  -e, --echo-queries       echo commands sent to server
  -E, --echo-hidden        display queries that internal commands generate

Need Your Help

iPhone Dev = maps and deselecting annotations

iphone mapkit annotations

I am successfully drawing annotations on a map using an array of annotations. I can even click on the annotation and change it’s colour or image. My problem arises when the use selects the second

TortoiseGitMerge customization

tortoisegit tortoisemerge tortoisegitmerge

Is there any way to make TortoiseGitMerge highlighted section be same as in TortoiseMerge without resizing window?