Re: Have \d show child tables that inherit from the specified parent

On Tuesday 07 July 2009 19:35:54 Tom Lane wrote:
> Peter Eisentraut <peter_e@gmx.net> writes:
> > On Sunday 10 May 2009 03:05:48 damien@dalibo.info wrote:
> >> Here's a second version. Main changes are :
> >>
> >> * Child tables are sorted by name
> >> * \d only shows the number of child tables
> >> * \d+ shows the full list
> >
> > Committed.
>
> I looked at this patch.  I'm a bit disturbed by the
>     ORDER BY c.oid::pg_catalog.regclass
> business.  I doubt that does what the author thinks, and I'm not sure
> what we really want anyway.  If we want the child table names sorted
> alphabetically then the regclass value needs to be further cast to text,
> ie
>     ORDER BY c.oid::pg_catalog.regclass::pg_catalog.text

Fixed; it was clearly meant to be by name.

Creation order might be useful, but we don't really support that anywhere 
else.