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

On Thu, Feb 26, 2009 at 12:25:08AM +0100, damien clochard wrote:
> Hello,
> 
> Last week, i took some time to check if i was still able to write
> some basic C code.  So i looked into the TODO list and picked some
> trivial items.
> 
> This one is very basic, it just shows the child tables of a specific
> table when you type \d <tablename> in psql :
> 
> 
> # create table mother(id SERIAL);
> # create table daughter() inherits(mother);
> # create table daughter2() inherits(mother);
> # create schema plop;
> # create table plop.daughter3() inherits(mother);
> # \d mother
>                          Table "public.mother"
>  Column |  Type   |                      Modifiers
> --------+---------+-----------------------------------------------------
>  id     | integer | not null default nextval('mother_id_seq'::regclass)
> Child tables: daughter,
>               daughter2,
>               plop.daughter3
> 
> 
> I understand that it may not be the best moment to submit such a
> trivial patch, as most of you are working hard on more important
> topics.  If you think i should submit it later, just let me know.
> 
> BTW, this is the first patch i submit so any comment is more than
> welcome.

Should the patch (and the feature) use WITH RECURSIVE in order to get
the entire tree?

Cheers,
David (yes, I know it's predictable from me, but WITH RECURSIVE really
is a neat new toy ;)
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate