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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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 | Content-Type | Size |
---|---|---|
psql_show_child_tables.v1.patch | text/x-patch | 1.5 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2009-02-25 23:26:03 | Re: effective_cache_size less than shared_buffers |
Previous Message | Kevin Grittner | 2009-02-25 23:21:20 | effective_cache_size less than shared_buffers |