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(at)gmx(dot)net> writes:
> > On Sunday 10 May 2009 03:05:48 damien(at)dalibo(dot)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.