what is it that \d actually does

Started by Geoffreyabout 18 years ago3 messagesgeneral
Jump to latest
#1Geoffrey
lists@serioustechnology.com

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

#2Scott Marlowe
scott.marlowe@gmail.com
In reply to: Geoffrey (#1)
Re: what is it that \d actually does

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

#3Merlin Moncure
mmoncure@gmail.com
In reply to: Scott Marlowe (#2)
Re: what is it that \d actually does

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