COMMENT and inheritance

From: Kaloyan Iliev <news1(at)faith(dot)digsys(dot)bg>
To: pgsql-general(at)postgresql(dot)org
Subject: COMMENT and inheritance
Date: 2006-04-17 16:44:04
Message-ID: 4443C5D4.6040604@faith.digsys.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello All,

I want to ask is there a way to inherit table column comments. I have a
table that is base for almost all other tables in my database (they
inherit it).
So the new tables receive their fields from the base table. But if I
want to put comments on this fields I must write COMMENT for every table
and columnt(nevertheless that they are all the same). So shouldn't it be
good if there is no comment for the column in the child table but there
is comment in the parent the comment to apear in the \d+ for the child
table. I write comments to use postgresql_autodoc and this blank columns
really makes me trouble.

Thanks for the answers in advance.

Kaloyan Iliev

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-04-17 16:58:10 Re: Syntax Help Requested
Previous Message Rich Shepard 2006-04-17 16:39:42 Syntax Help Requested