| 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: | Whole Thread | Raw Message | 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 |