Re: List schema contents

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: List schema contents
Date: 2006-06-09 21:00:01
Message-ID: 20060609210000.GJ57289@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-www

On Fri, Jun 09, 2006 at 04:55:07PM -0400, Tom Lane wrote:
> "Jim C. Nasby" <jnasby(at)pervasive(dot)com> writes:
> > What I'm looking for is what "\d" provides you, only limited to a
> > specific schema. "\d information_schema." (for example) doesn't provide
> > that; it provides the details for every table/view in
> > information_schema.
>
> What you're looking for is \dt, or perhaps \dtsv or one of those forms.

\dtsv produces exactly what I'd want/expect.

> 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?
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-06-09 21:08:40 Re: List schema contents
Previous Message Tom Lane 2006-06-09 20:55:07 Re: List schema contents

Browse pgsql-www by date

  From Date Subject
Next Message Tom Lane 2006-06-09 21:08:40 Re: List schema contents
Previous Message Tom Lane 2006-06-09 20:55:07 Re: List schema contents