Horton
Menu

Re: MySQL-ism help patch for psql

Andrew Dunstan <andrew@dunslane.net>

View thread
From: Andrew Dunstan <andrew@dunslane.net>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Peter Eisentraut <peter_e@gmx.net>, Bruce Momjian <bruce@momjian.us>, David Christensen <david@endpoint.com>, Tom Lane <tgl@sss.pgh.pa.us>, Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>, Jeff Davis <pgsql@j-davis.com>, pgsql-hackers@postgresql.org, Magnus Hagander <magnus@hagander.net>
Date: 2010-01-20T15:00:05Z
Lists: pgsql-hackers 

Robert Haas wrote:
> I'm actually no big advocate of the \d commands.  They're basically
> magical queries that you can't easily see or edit - I've more than
> once wished for a WHERE clause (\df WHERE "Result data type" =
> 'internal' or what have you.  
>   

You *can* easily see them, at least. Run "psql -E" or inside psql do 
"\set ECHO_HIDDEN"

cheers

andrew