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-----
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 |