Re: Have \d show child tables that inherit from the specified parent - Mailing list pgsql-hackers

From Greg Sabino Mullane
Subject Re: Have \d show child tables that inherit from the specified parent
Date
Msg-id 3b7d9fce5e9d7dc6d92b3df2e8eb2b75@biglumber.com
Whole thread Raw
In response to Re: Have \d show child tables that inherit from the specified parent  ("damien@dalibo.info" <damien@dalibo.info>)
Responses Re: Have \d show child tables that inherit from the specified parent  (Euler Taveira de Oliveira <euler@timbira.com>)
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


> * Child tables are sorted by name
> * \d only shows the number of child tables
> * \d+ shows the full list

> This table has 4 child table(s). Use \d+ to display them.

Would be nice if you could get rid of that ugly '(s)' part.

> Child tables: daughter,
>              daughter2,
>              daughter3,
>              plop.daughter4
> Has OIDs: no

Since the child list can be rather long, it's probably better to put
everything else first, e.g. the "Has OIDs" line.

> For people having hundreds of child tables, the use of \d+ will still be
> uncomfortable. But i must admit that i can't see any better way to
> implement this feature, except by adding a new syntax ( \dh to show
> specific information about inheritance ? )

I think the \d+ is a good compromise.

- --
Greg Sabino Mullane greg@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 200905102120
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAkoHfZ8ACgkQvJuQZxSWSsjIiACfWHH+YbUPMxanDdUTprbtHz+T
FzwAn1GVzEArQLAPSJIAKWnMXGHvpdG1
=+oo1
-----END PGP SIGNATURE-----




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #4721: All sub-tables incorrectly included in search plan for partitioned table
Next
From: KaiGai Kohei
Date:
Subject: Re: [PATCH] unalias of ACL_SELECT_FOR_UPDATE