To: "Jim C. Nasby" <jnasby@pervasive.com>
cc: pgsql-hackers@postgresql.org
Subject: Re: List schema contents 
In-reply-to: <20060609210000.GJ57289@pervasive.com> 
References: <20060609193356.GC57289@pervasive.com>
	<24470.1149884416@sss.pgh.pa.us>
	<20060609202741.GF57289@pervasive.com>
	<24709.1149886507@sss.pgh.pa.us>
	<20060609210000.GJ57289@pervasive.com>
Comments: In-reply-to "Jim C. Nasby" <jnasby@pervasive.com>
	message dated "Fri, 09 Jun 2006 16:00:01 -0500"
Date: Fri, 09 Jun 2006 17:08:40 -0400
Message-ID: <24834.1149887320@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

"Jim C. Nasby" <jnasby@pervasive.com> writes:
> On Fri, Jun 09, 2006 at 04:55:07PM -0400, Tom Lane wrote:
>> I'd be the first to agree that the behavior of \d isn't particularly
>> orthogonal, but it's not the pattern language that's the problem, it's
>> the command itself.

> Perhaps \d without an argument should just do whatever \dtsv does?

That's exactly what it does ... without an argument.  The
non-orthogonality is that adding an argument changes the printout style,
instead of just determining which objects are displayed.  See the psql
man page:

         Note: If \d is used without a pattern argument, it is
         equivalent to \dtvs which will show a list of all 
         tables, views, and sequences. This is purely a convenience measure. 

			regards, tom lane