Skip site navigation (1) Skip section navigation (2)

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

From: damien clochard <damien(at)dalibo(dot)info>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Have \d show child tables that inherit from the specified parent
Date: 2009-02-25 23:25:08
Message-ID: 49A5D354.7000609@dalibo.info (view raw or flat)
Thread:
Lists: pgsql-hackers
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.

Regards,

--
damien clochard
dalibo.com | dalibo.org

Attachment: psql_show_child_tables.v1.patch
Description: text/x-patch (1.5 KB)

Responses

pgsql-hackers by date

Next:From: Joshua D. DrakeDate: 2009-02-25 23:26:03
Subject: Re: effective_cache_size less than shared_buffers
Previous:From: Kevin GrittnerDate: 2009-02-25 23:21:20
Subject: effective_cache_size less than shared_buffers

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group