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

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: damien(at)dalibo(dot)info
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Have \d show child tables that inherit from the specified parent
Date: 2009-05-11 01:21:40
Message-ID: 3b7d9fce5e9d7dc6d92b3df2e8eb2b75@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)turnstep(dot)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-----

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message KaiGai Kohei 2009-05-11 02:35:30 Re: [PATCH] unalias of ACL_SELECT_FOR_UPDATE
Previous Message Tom Lane 2009-05-10 23:23:45 Re: [BUGS] BUG #4721: All sub-tables incorrectly included in search plan for partitioned table