Greg Sabino Mullane wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: RIPEMD160
>
>
>> This one is very basic, it just shows the child tables of a specific
>> table when you type \d <tablename> in psql :
>
> I'm not so jazzed about this, as I work on systems that have literally
> hundreds of child tables.
hi everyone.
Thanks for your comments.
I must admit that i didn't asked myself much questions when i
implemented that feature. As i said i picked that item almost randomly
in the todo list. I choosed to show child table on \d instead \d+ in
order to be consistant with the fact that \d shows the mother of the
specified table.
That being said i recognize that people who have dozens of child tables
might get annoyed by this patch.
Here's 3 ideas that could make things better :
1- When using \d , only show the numbers of child tables
2- Only display the list of child table when \d+ is used. (mode ???)
3- Display the child table names in line, instead of one line per table.
Here's what it would look like :
# \d mother Table "public.mother" Column | Type | Modifiers
--------+---------+----------------------------------------------------- id | integer | not null default
nextval('mother_id_seq'::regclass)
This table has 5 child tables. Use \d+ to display them.
#\d+ mother Table "public.mother" Column | Type | Modifiers
--------+---------+----------------------------------------------------- id | integer | not null default
nextval('mother_id_seq'::regclass)
Child tables : daughter1, daughter2, daughter3, daughter4, daughter5
Does it look better ?
--
damien clochard
dalibo.org | dalibo.com