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: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers

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,

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.


damien clochard |

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


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-2018 The PostgreSQL Global Development Group