Re: List schema contents - Mailing list pgsql-hackers

From Tom Lane
Subject Re: List schema contents
Date
Msg-id 24470.1149884416@sss.pgh.pa.us
Whole thread Raw
In response to List schema contents  ("Jim C. Nasby" <jnasby@pervasive.com>)
Responses Re: List schema contents
List pgsql-hackers
"Jim C. Nasby" <jnasby@pervasive.com> writes:
> I'd like to propose that the behavior of \d schemaname. be changed to
> match

> set search_path = schemaname
> \d

I'm not sure what your reasoning is here, but AFAICS this would move the
behavior away from what you say you want.  What exactly have you got
in mind, and why?  In particular, why do you think that "\d schemaname."
doesn't already produce exactly what you asked for, namely a list of the
tables in that schema?  The above would *not* produce such a list
(counterexample: temp tables).

> One problem I see is that this will break the ability to search for
> tablename. via regex.

You are aware of the double-quoting option in \d search patterns, no?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: List schema contents
Next
From: "Jim C. Nasby"
Date:
Subject: Re: List schema contents